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-12060: shape of prebuilt table does not match definition query
ORA-25119: LOGGING/NOLOGGING option already specified
SQL*Loader-00251: Sort devices are not used by SQL*Loader
ORA-30680: debugger connection handshake failed
KUP-04061: directory object string specified for LOBFILE column string is not valid
NNL-01055: Requests received: number
ORA-02072: distributed database network protocol mismatch
RMAN-06576: platform 'string' (number) found in header of datafile string does not mmatch specified platform name 'string' (number)
VID-00703: unable to read video data
NNF-02001: NIS client error string: string
ORA-14611: Duplicate subpartition name string in template
NZE-29095: Index is not correct.