ORA-02449: unique/primary keys in table referenced by foreign keys - Oracle Database 12c Error Msg

Channel:

java frm

Subscribers:

5,740

Published on March 15, 2023 6:27:32 PM ● Video Link: https://www.youtube.com/watch?v=8GpMWUYfq3s

Duration: 1:15

1 views

0

In this video we are going to see how to fix below Oracle Database 12c Error Message.

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";

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database