ORA-02266: unique/primary keys in table referenced by
enabled foreign keys
- 1 Answers
- 3303 Views
- I also Faced
- E-Mail Answers
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-30205: invalid Character set
IMG-00602: unable to access image data
ORA-39315: illegal swap() call: only applys after clone/sync_code
PCC-02338: structure contains a nested struct or union
ORA-12606: TNS: Application timeout occurred
DRG-10599: column is not indexed
SQL*Loader-00131: Invalid multithreading option
ORA-16002: database already open for read-write access by another instance
DRG-10831: can not insert into feedback table string
ORA-28292: No Domain Policy registered for Kerberos based authentication
ORA-06512: at stringline string
ORA-16532: Data Guard broker configuration does not exist.
Oracle Errors 
