How to Avoid Generation of Redolog Entries (Doc ID 188691.1)

***Checked for relevance on 25-Jul-2010***

• 
  
• goal: How to Avoid Generation of Redolog Entries
  
• fact: Oracle Server - Enterprise Edition 8.1
  
• fact: Oracle Server - Enterprise Edition 9.0.1
  
• fact: Oracle Server - Enterprise Edition 9.2
  
• fact: Oracle Server - Enterprise Edition 10.1
  
• fact: Oracle Server - Enterprise Edition 10.2
  
• fact: Oracle Server - Enterprise Edition 11.1
  
• fact: Oracle Server - Enterprise Edition 11.2
  

fix:

The option NOLOGGING valid since Oracle8 can be used to avoid
the redolog entries generation for a certain operation,
that can be easily recovered without using the database
recovery mechanism.

The following operations can make use of nologging mode:

- 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 /*+APPEND*/ INTO

References

http://docs.oracle.com/cd/E11882_01/server.112/e26088/clauses005.htm#SQLRF30009

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27348/viewspace-767351/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27348/viewspace-767351/