SELECT
SUPPLEMENTAL_LOG_DATA_MIN,
SUPPLEMENTAL_LOG_DATA_PK,
SUPPLEMENTAL_LOG_DATA_UI
FROM
V$DATABASE;
Code: Select all
SUPPLEME SUP SUP
-------- --- ---
YES YES YES
SQL>
SQL>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
How to disable supplemental logging at database level?ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE,
FOREIGN KEY) COLUMNS;
SQL>
ALTER DATABASE DROP SUPPLEMENTAL LOG DATA;