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.