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



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

More Oracle Errors Interview Questions

ORA-13839: V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.

1 Answers  


LSX-00255: mismatched parentheses

1 Answers  


PLS-00308: this construct is not allowed as the origin of an assignment

1 Answers  


ORA-24808: streaming of lob data is not allowed when using lob buffering

1 Answers  


ORA-07647: sszfck: $OPEN failure

1 Answers  






ORA-23610: internal dbms_streams_tablespaces error: [string] [string] [string] [string]

1 Answers  


ORA-12598: TNS:banner registration failed

1 Answers  


ORA-37086: %s is not a valueset

1 Answers  


PCC-02348: indicators are not allowed in EXEC IAF statements

1 Answers  


NZE-29015: incorrect message length

1 Answers  


LPX-00214: CDATA section did not end in "]]>"

1 Answers  


QSM-01028: materialized view, string, is currently being refreshed

1 Answers  


Categories