ORA-02429: cannot drop index used for enforcement of unique/primary key

SQL> drop index UUID_PK;
drop index UUID_PK
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key

SQL>

SQL> select owner,CONSTRAINT_NAME,TABLE_NAME,CONSTRAINT_TYPE from user_constraints where table_name='TEMP_TRIAL_3006';

OWNER CONSTRAINT_NAME TABLE_NAME C
------------------------------ ------------------------------ ------------------------------ -
YXY UUID_PK TEMP_TRIAL_3006 P
YXY SYS_C0034171 TEMP_TRIAL_3006 C

SQL> alter table TEMP_TRIAL_3006 drop constraint SYS_C0034171;

Table altered.

SQL> alter table TEMP_TRIAL_3006 drop constraint uuid_pk ;

Table altered.

SQL> select index_name,table_name from user_indexes where table_name='TEMP_TRIAL_3006';

no rows selected

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7364032/viewspace-17456/，如需轉載，請註明出處，否則將追究法律責任。