ORA-02266 unique/primary keys in table referenced by enabled foreign keys
Cause
An attempt was made to drop or truncate a table with unique or primary keys referenced by foreign keys enabled in another table.
Action
Before dropping or truncating 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 constraint_name, table_name, status
from user_constraints
where r_constraint_name in (
select constraint_name from user_constraints where table_name
='tabnam');
refer to following url:
http://turfybot.free.fr/oracle/8i/errors/ORA-02266.html
Cause
An attempt was made to drop or truncate a table with unique or primary keys referenced by foreign keys enabled in another table.
Action
Before dropping or truncating 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 constraint_name, table_name, status
from user_constraints
where r_constraint_name in (
select constraint_name from user_constraints where table_name
='tabnam');
refer to following url:
http://turfybot.free.fr/oracle/8i/errors/ORA-02266.html