Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

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;

 

 

  • No labels