Oracle Database - Table Logging Mode (LOGGING, NOLOGGING)

About

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

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;

NOLOGGING


Powered by ComboStrap