ITPub博客

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

原创 Linux操作系统 作者:yxyup 时间:2007-03-02 00:00:00 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: dp测试小记
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-06

  • 博文量
    164
  • 访问量
    1314302