Although you can set the NOLOGGING attribute for a table, index, or tablespace, Nologging mode only applies to a few operations on the object for which the attribute is set, such as:
?
CREATE TABLE ... AS SELECT
?
CREATE INDEX
?
ALTER INDEX ... REBUILD
?
DIRECT PATH INSERT
The following statements are nevertheless unaffected by the NOLOGGING attribute: UPDATE, DELETE, conventional path INSERT, and various DDL statements not listed above.
即使你在table,index,tablespace上设置了nologging属性,但对于update,delete,conventional path INSERT以及上述没有提到的ddl语句都不会受nologging属性影响。
比如你的表是nologging的,但你做insert插入,也是有redo log entries产生的。你可以自己试试看,insert,update,delete都是可以rollback的。
|