Oracle Error ORA-32589: unable to drop minimal supplemental logging

Oracle Error Message

ORA-32589: unable to drop minimal supplemental logging

Reason for the Error

Minimal supplemental logging could not be dropped as one of primary key, foreign key, unique or all column supplemental logging is enabled at the database level.

Solution

Use V$DATABASE to determine the databasewide supplemental logging directives. Minimal supplemental logging could be dropped if and only if no other databasewide supplemental logging directives are enabled.