oracle中 keys,案例:Oracle报错ORA-02266:unique/primary keys in table ....foreign keys

天萃荷净

开发DBA反映在执行truncate清空一张表记录发现ORA-02266，进行模拟测试分析原因为存在主外键或索引导致

1.truncate清空表报ORA-02266错误

SQL> truncate table p;

truncate table p

*

ERROR at line 1:

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

--错误原因

SQL> !oerr ora 02266

02266, 00000, "unique/primary keys in table referenced by enabled foreign keys"

// *Cause: An attempt was made to truncate a table with unique or

//         primary keys referenced by foreign keys enabled in another table.

//         Other operations not allowed are dropping/truncating a partition of a

//         partitioned table or an ALTER TABLE EXCHANGE PARTITION.

// *Action: Before performing the above operations the table, disable the

//          foreign key constraints in other tables. You can see what

//          constraints