ORA-32589:unable to drop minimal supplemental logging
July 12, 2011 Leave a comment
Error: ORA-32589: unable to drop minimal supplemental logging
Cause: Minimal supplemental logging cannot be dropped until one of the PRIMARY KEY, FOREIGN KEY, UNIQUE or ALL COLUMN supplemental logging is enabled.
For example: You may have enabled the following supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
And now trying to turn off supplemental logging like this:
ALTER DATABASE DROP SUPPLEMENTAL LOG DATA;
Action: Use the following query to determine which supplemental logging is turned on:
select supplemental_log_data_min ,supplemental_log_data_all ,supplemental_log_data_pk ,supplemental_log_data_ui from v$database
For example: If the output is the following:
SUPPLEMENTAL_LOG_DATA_MIN SUPPLEMENTAL_LOG_DATA_ALL SUPPLEMENTAL_LOG_DATA_PK SUPPLEMENTAL_LOG_DATA_UI
------------------------- ------------------------ ------------------------ ------------------------
IMPLICIT NO YES NO
Do the following:
ALTER DATABASE DROP SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
And then:
ALTER DATABASE DROP SUPPLEMENTAL LOG DATA;
About Mariami Kupatadze
DBA Knowledge Base 