Turn remove or turn off supplemental logging at the database level
Section |
---|
Column |
---|
|
panel No Format |
---|
|
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
Section |
---|
Column |
---|
|
Panel |
---|
No Format |
---|
|
SQL> SELECT SELECT supplementalsupplemental_log_data_min MIN, supplemental
supplemental_log_data_pk PK, supplemental
supplemental_log_data_ui UI, supplemental
supplemental_log_data_fk FK,
supplemental_log_data_all "ALL" FROM
FROM v$database; |
...