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-16179: incremental changes to "string" not allowed with SPFILE
ORA-01681: max # extents (string) reached in LOB segment in tablespace string
LPX-00604: Invalid attribute value '~1S', for attribute '~2s'.
ORA-14403: cursor invalidation detected after getting DML partition lock
TNS-12679: Native services disabled by other process but required
ORA-21704: cannot terminate cache or connection without flushing first
ORA-09365: Windows 3.1 Two-Task driver unable to destroy hidden window
ORA-26086: direct path does not support triggers
PCC-01017: The SQLCA and a SQLCODE variable cannot both be used
ORA-23537: function or procedure string is not allowed to be invoked from this site.
NID-00451: Succesfully changed database name.
CLSR-00511: Error number encountered when handling incoming EVM message