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

Popular Posts:

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

ISNULL() - Replacing...

How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

NULLIF() - Replacing...

How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...

"CREATE PROCEDURE" -...

How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...