删除索引主键约束引时ORA-02429错误的解决方法：
select table_name from user_indexes where INDEX_NAME = '&index_name'
select index_name,table_NAME from USER_indexes where table_name='TSP_INDEXIMAGES';
SELECT CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME,INDEX_NAME FROM ALL_CONSTRAINTS WHERE TABLE_NAME='&TABLE';
SQL> DROP INDEX PK;
DROP INDEX PK
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key
SQL> ALTER TABLE TSP_INDEXIMAGES MODIFY PRIMARY KEY DISABLE;
SQL> DROP INDEX PK;
Index dropped.
SQL> ALTER TABLE TSP_INDEXIMAGES MODIFY PRIMARY KEY enable
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29371470/viewspace-1062587/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
