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 |
NCR-04017: NCRR: Unable to find the interface instance handle
ORA-01970: You must specify a database name for CREATE CONTROLFILE
UDE-00006: failed to allocate memory of size number
PLS-00248: Invalid Library Syntax
ORA-38404: schema extension not allowed for the attribute set name
DGM-16949: "string" was not found
RMAN-08044: channel string: finished piece string at string
CLSS-00101: Oracle Cluster Repository mismatch with node string. (string != string)
TNS-04008: %-25s | string
ORA-31608: specified object of type string not found
IMP-00080: Error during character conversion of long column or long command
ORA-32602: FREEPOOLS and FREELIST GROUPS cannot be used together