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 |
ORA-13839: V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.
LSX-00255: mismatched parentheses
PLS-00308: this construct is not allowed as the origin of an assignment
ORA-24808: streaming of lob data is not allowed when using lob buffering
ORA-07647: sszfck: $OPEN failure
ORA-23610: internal dbms_streams_tablespaces error: [string] [string] [string] [string]
ORA-12598: TNS:banner registration failed
ORA-37086: %s is not a valueset
PCC-02348: indicators are not allowed in EXEC IAF statements
NZE-29015: incorrect message length
LPX-00214: CDATA section did not end in "]]>"
QSM-01028: materialized view, string, is currently being refreshed