nologging與append zt

最近，因為常常需要對大表進行操作，所以，對於nologging的需要也更加多了，系統地看了一些關於nologging的文章，如下是tom給出的一個nologging與append對應表

Table Mode Insert Mode ArchiveLog mode result
----------- ------------- ----------------- ----------
LOGGING APPEND ARCHIVE LOG redo generated
NOLOGGING APPEND ARCHIVE LOG no redo
LOGGING no append "" redo generated
NOLOGGING no append "" redo generated
LOGGING APPEND noarchive log mode no redo
NOLOGGING APPEND noarchive log mode no redo
LOGGING no append noarchive log mode redo generated
NOLOGGING no append noarchive log mode redo generated

It will only NOT generate redo in the 3 cases above:

o Object is NOLOGGING and database is ARCHIVE LOG
o Object is either NOLOGGING or LOGGING and database is NO ARCHIVE LOG

[@more@]適用於nologging的操作 [回覆]

direct load (SQL*Loader)
direct-load INSERT
CREATE TABLE ... AS SELECT
CREATE INDEX
ALTER TABLE ... MOVE PARTITION
ALTER TABLE ... SPLIT PARTITION
ALTER INDEX ... SPLIT PARTITION
ALTER INDEX ... REBUILD
ALTER INDEX ... REBUILD PARTITION
INSERT, UPDATE, and DELETE on LOBs in NOCACHE NOLOGGING mode stored out of line