Disabling supplemental logging

Owned by Copy Space for Confluence
Jan 22, 2017
1 min read

Turn remove or turn off supplemental logging at the database level

SQL> alter database drop supplemental log data;

 

Supplemental logging can also be turned on per table. Use the following query to determine what has been turned on to disable

SQL> SELECT supplemental_log_data_min MIN, 
supplemental_log_data_pk PK, 
supplemental_log_data_ui UI, 
supplemental_log_data_fk FK,
supplemental_log_data_all "ALL" 
FROM v$database;