How to resolve Dropping of an index on AA table - SQL Error: ORA-02429 ?
*** Note any constraint that is defined needs to be dropped as in the example below the Constraint/Primary Key (PK_ARUDS_USERAUDITLOG) is defined on the table ARUDSUSERAUDITLOG. This constraint has to be dropped before dropping the index. The example below uses syntax on a Oracle Database.
ALTER TABLE ARUDSUSERAUDITLOG
DROP CONSTRAINT PK_ARUDS_USERAUDITLOG;
DROP INDEX PK_ARUDS_USERAUDITLOG;