After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent beer selection!
|
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
;
|
|
|
|
