Oracle Database - Table Logging Mode (LOGGING, NOLOGGING)

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.

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


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap