Tag Archives: ORA-02449

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

oracle

ORA-02449: unique/primary keys in table referenced by foreign Keys
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”;

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/