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

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

Question Posted / guest

1 Answers
3617 Views
I also Faced
E-Mail Answers

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

Answer / guest

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";

Please add more information about this Error

Is This Answer Correct ?

1 Yes

0 No

Post New Answer