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.

 

Dropped Tables with Indexes in Oracle

Drop an Index in Oracle

Managing Oracle Table Indexes

⇑⇑ Oracle Database Tutorials

2023-05-09, 3210🔥, 1💬