Oracle DBA, How To, Error, Cause and Action

ORA-02429: cannot drop index used for enforcement of unique/primary key

ORA-02429: cannot drop index used for enforcement of unique/primary key




Cause: user attempted to drop an index that is being used as the enforcement mechanism for unique or primary key.




Action: drop the constraint instead of the index.