最近,因为常常需要对大表进行操作,所以,对于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
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/82387/viewspace-1016305/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/82387/viewspace-1016305/