truncate table时发生ORA-02266错误
SQL> conn johnny/johnny
Connected.
SQL> truncate table claims;
truncate table claims
*
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

SQL> !oerr ora 2266
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 are referencing a table by issuing the following
//           command:
//           SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";

SQL> select constraint_name,constraint_type,status from user_constraints where table_name='CLAIMS';

CONSTRAINT_NAME                C STATUS
------------------------------ - --------
SYS_C0052660                   C ENABLED
SYS_C0052661                   C ENABLED
CLAIMS_PK                      P DISABLED
SQL> alter table claims disable primary key cascade;

Table altered.

SQL> truncate table claims;

Table truncated.

SQL> alter table claims enable primary key;

Table altered.

SQL> select constraint_name,constraint_type,status from user_constraints where table_name='CLAIMS';

CONSTRAINT_NAME                C STATUS
------------------------------ - --------
SYS_C0052660                   C ENABLED
SYS_C0052661                   C ENABLED
CLAIMS_PK                      P ENABLED

ITPub博客

truncate table时发生ORA-02266

最新文章