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 |
TNS-02513: Requested data type does not match retrieved type
ORA-12024: materialized view log on "string"."string" does not have primary key columns
NZE-29009: Bad encrypted key length when using SSL 2.0
QSM-02047: window function in mv
ORA-32624: illegal reordering of MODEL dimensions
ORA-12635: No authentication adapters available
ORA-27063: number of bytes read/written is incorrect
IMG-00902: VIR signature free failed
ORA-16706: no resource guard is available
CLSR-01002: Unable to process instance startup
ORA-15123: ASM file name 'string' contains an invalid incarnation number
ORA-12100: materialized view log on "string"."string" already has sequence