Error: Cannot Drop Index on Primary Key in Oracle


Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle?



You can not delete the index associated with a unique or primary key constraint. If you try, you will get an error like this: ORA-02429: cannot drop index used for enforcement of unique/primary key.


Dropped Tables with Indexes in Oracle

Drop an Index in Oracle

Managing Oracle Table Indexes

⇑⇑ Oracle Database Tutorials

2023-05-09, 3210🔥, 1💬