Error: Cannot Drop Index on Primary Key in Oracle

Q

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

✍: FYIcenter.com

A

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.

 

Managing Oracle Table Indexes

⇒⇒Oracle Database Tutorials

2016-10-17, 221👍, 0💬