Oracle - Error: Cannot Drop Index on Primary Key in Oracle

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, 194👍, 0💬

Popular Posts:

CONVERT() - Converti...

How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...

Ending Stored Proced...

How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...

FLOOR, CEILING, ROUN...

How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...

CONTINUE to Next Loo...

How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...