Oracle Database - NOLOGGING

> Database > Oracle Database

1 - About

A table of a statement marked as NOLOGGING will bypass the Oracle Database - Redo Log (Transaction Log Files) generation.

Just setting a table to NOLOGGING does not mean that all redo is prevented against this table.
Only certain, Data Processing - (Batch|Bulk) Processing operation, such as direct path insert, will not be logged in the normal fashion. All other operation such as insert, update, delete and merge, will be logged as normal.


3 - DDL

ALTER TABLE big_table nologging;

4 - Recovery

The operation will not be logged and then you prevent the redo log to be generated. It's not in the archive log and it cannot be recovered.