ORA-02449

错误

drop table T_LX_AUTHORITY
           *
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys

错误描述

$ oerr ORA 02449
02449, 00000, "unique/primary keys in table referenced by foreign keys"
// *Cause: An attempt was made to drop a table with unique or
//         primary keys referenced by foreign keys in another table.
// *Action: Before performing the above operations the table, drop the
//          foreign key constraints in other tables. You can see what
//          constraints are referencing a table by issuing the following
//          command:
//          SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";

意思是说其他外建引用了表的主建/唯一

禁用此约束

用action中提示的cmd

SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";

SELECT CONSTRAINT_NAME,CONSTRAINT_TYPE FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";

解除

alter table TABLE_NAME disable constraint CONSTRAINT_NAME CASCADE;

删除表

drop table TABLE_NAME

如果出错用如下语句

drop table TABLE_NAME cascade constraints;

###################################

迷途小运维随笔

作者：john

转载请注明出处