Of Interest
Business Intelligence and Analytics
Oracle Training
|
Oracle
»
DDL
»
performance
»
Creating a table with NOLOGGING clause
When creating a table, you can add the NOLOGGING clause which
allows some operations to go by as unlogged (thus are faster
and less prone to redo issues).
The NOLOGGING clause specifies that subsequent direct
loads using SQL-Loader and direct load INSERT operations
are not logged.
Note! DML statements (UPDATE, DELETE, and conventional path insert)
are unaffected by the NOLOGGING attribute of the table and generate redo.
Sample:
CREATE TABLE INVOICE_ITEM
(
INVOICE_ID NUMBER NOT NULL,
ITEM_ID NUMBER NOT NULL,
LABEL VARCHAR2(20) NOT NULL,
SHIP_CD VARCHAR2(20) NOT NULL,
PRICE_VALUE NUMBER NOT NULL
)
nologging
tablespace TS23
;
|
|
|
Get the latest Rocket99 news and tech tips via
|
