Oracle Database - Table Logging Mode (LOGGING, NOLOGGING)


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


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;


Powered by ComboStrap