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

SQL> drop index TMP1_INX;
 
drop index TMP1_INX
 

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

解决方案：

SQL> ALTER TABLE employees
  2  2 MODIFY PRIMARY KEY DISABLE;

SQL>  drop index TMP1_INX;
 
Index dropped
 

SQL> create index tmp1_INX on tmp1 (DEALER_ID, CO_NO) local compress;  
 
Index created
 

SQL>  ALTER TABLE tmp1 MODIFY PRIMARY KEY ENABLE;
 
Table altered
 

注：由于有个字段在主键中，主键详见下面：

alter table TMP1
  add constraint PK_TMP1 primary key (CO_NO, DEALER_ID);