Oracle Database - Table Logging Mode (LOGGING, NOLOGGING)

Card Puncher Data Processing

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

Oracle Database - NOLOGGING







Share this page:
Follow us:
Task Runner