|
  OraDev.com
|
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
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";
To solve this: disable or drop the foreign key:
You can disable a foreign key with name 'constraint_name' with the command:
alter table disable CONSTRAINT 'constraint_name';
alter table drop CONSTRAINT 'constraint_name';
|
|
|
|
|
|
|