ORA-02449: unique/primary keys in table referenced by foreign keys

ORA-02449: unique/primary keys in table referenced by
foreign keys

Question Posted / guest

1 Answers
3584 Views
I also Faced
E-Mail Answers

ORA-02449: unique/primary keys in table referenced by foreign keys..

Answer / guest

Cause: An attempt was made to drop a table with unique or
primary keys referenced by foreign keys in another table.

Action: Before performing the above operations the table,
drop 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 ?

0 Yes

0 No

Post New Answer