oracle 以下操作中,不產生redo log

[@more@]
DML:

Direct-path INSERT (serial or parallel)

Direct Loader (SQL*Loader)

DDL:

CREATE TABLE ... AS SELECT

CREATE TABLE ... LOB_storage_clause ... LOB_parameters ... NOCACHE | CACHE READS

ALTER TABLE ... LOB_storage_clause ... LOB_parameters ... NOCACHE | CACHE READS (for specify logging of newly created LOB columns)

ALTER TABLE ... modify_LOB_storage_clause ... modify_LOB_parameters ... NOCACHE | CACHE READS (to change logging of existing LOB columns)

ALTER TABLE ... MOVE

ALTER TABLE ... [all partition operations that involve data movement]

ALTER TABLE ... ADD PARTITION (hash partition only)

ALTER TABLE ... MERGE PARTITIONS

ALTER TABLE ... SPLIT PARTITION

ALTER TABLE ... MOVE PARTITION

ALTER TABLE ... MODIFY PARTITION ... ADD SUBPARTITION

ALTER TABLE ... MODIFY PARTITION ... COALESCE SUBPARTITION

ALTER TABLE ... MODIFY PARTITION ... REBUILD UNUSABLE INDEXES

CREATE INDEX

ALTER INDEX ... REBUILD

ALTER INDEX ... REBUILD PARTITION

ALTER INDEX ... SPLI

oracle support nologging ddl dml

相關文章