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-16751: Resource guard encountered errors in switchover to primary
TNS-00094: * to status - argument is considered the remote process_name
ORA-25299: Cannot add buffered subscriber for a non-buffered queue
ORA-01411: cannot store the length of column in the indicator
NZE-29045: Renegotiation request has been refused.
ORA-25200: invalid value string, QUEUE_NAME should be [SCHEMA.]NAME
ORA-13213: failed to generate spatial index for window object
ORA-01621: cannot rename member of current log if database is open
ORA-32133: Cannot get stream from LOB/FILE
ORA-13156: table to be registered string.string is not empty
ORA-02034: speed bind not permitted
ORA-19862: backup pieces must be validated before accessing results