Oracle Database - Table Logging Mode (LOGGING, NOLOGGING)

> Database > Oracle Database

1 - About

The logging mode of the target table (LOGGING, NOLOGGING) is what will dictate whether redo log is generated for the table or not.

Advertising

3 - LOGGING

A table marked as LOGGING will generate redo in the Oracle Database - Redo Log (Transaction Log Files) while a table marked as Oracle Database - NOLOGGING will bypass it.

ALTER TABLE big_table logging;

4 - NOLOGGING

db/oracle/oradb_table_logging_mode.txt · Last modified: 2017/09/06 19:28 by gerardnico