ORA-00604 & ORA-02429

December 28

ORA-00604 & ORA-02429

problem:

1)

SQL> drop tablespace legend including contents;
drop tablespace legend including contents
*
ERROR 位于第 1 行:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-02429: 无法删除用于强制唯一/主键的索引

2)

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

solution:

1)删除用户，再删除表空间

drop user #user_name casacade;

drop tablespace #talbespace_name including contents;

 

2)在user_constraints中找到对应的constrait_name，然后再将该contraint drop或disable掉

select * from user_constraints  c where table_name =UPPER('g302t') and c.constraint_name='G302T_IDX1'

alter table #talbe_name drop constraint #constraint_name;

alter table #talbe_name modify #constraint_type  disable;