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-25000: invalid use of bind variable in trigger WHEN clause
TNS-01188: Listener cannot operate with incompatible transport protocols
ORA-26018: Column string in table string does not exist
ORA-12214: TNS:missing local communities entry in TNSNAV.ORA
RMAN-06403: could not obtain a fully authorized session
TNS-00307: Navigator: Reread parameter data
ORA-30374: materialized view is already fresh
ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified
ORA-02070: database stringstring does not support string in this context
ORA-16105: Logical Standby is already running in background
ORA-24184: transformation string.string, already exists
ORA-02036: too many variables to describe with automatic cursor open