Saturday, January 5, 2013

NOLOGGING In Oracle Databases

In Oracle there is a valuable feature where you can disable logging for only one table. In SQL Server maximum granularity you have is database level. So in case, you are doing lot of inserts or index rebuilding for only one table you have the option of disabling the logging for that table.

ALTER TABLE t1 NOLOGGING;

So above command will suspend the logging for table t1,


Only the following statements can make use of nologging:



Alter Table




  • Move Partition

  • Split Partition

  • Add Partition

  • Merge Partition

  • Modify Partition

Alter Index



  • Split Partition

  • Rebuild

  • Rebuild Partition

Create Table


Create Index


More info from following links


http://www.orafaq.com/wiki/Nologging_and_force_logging


http://www.adp-gmbh.ch/ora/misc/nologging.html


http://www.dba-oracle.com/t_nologging_append.htm


So I think it is good feature to have for SQL Server as well.

No comments:

Post a Comment