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.

Advertising

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.

db/oracle/nologging.txt · Last modified: 2018/10/10 11:06 by 108.162.237.98