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

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

Cause: An attempt was made to truncate a table with unique or primary keysreferenced by foreign keys enabled in another table. Other operations not allowed aredropping/truncating a partition of a partitioned table or an ALTER TABLEEXCHANGE PARTITION.61-12 Error Messages

Action: Before performing the above operations the table, disable the foreign keyconstraints in other tables. You can see what constraints are referencing a table byissuing the following command: SELECT * FROM USER_CONSTRAINTS WHERETABLE_NAME = “tabnam”;

  • February 19, 2019 | 18 views
  • Comments