ORA-02266: unique/primary keys in table referenced by enabled ... - Oracle Database 12c Error Msg

Channel:

java frm

Subscribers:

5,740

Published on March 14, 2023 10:13:20 AM ● Video Link: https://www.youtube.com/watch?v=ZpRcW_qgDDc

Duration: 2:32

4 views

0

In this video we are going to see how to fix below Oracle Database 12c Error Message.

ORA-02266: 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";

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database