SQL> drop index TMP1_INX;
drop index TMP1_INX
Index created
SQL> ALTER TABLE tmp1 MODIFY PRIMARY KEY ENABLE;
Table altered
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
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);