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



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

More Oracle Errors Interview Questions

ORA-02068: following severe error from stringstring

2 Answers  


ORA-12427: invalid input value for string parameter

1 Answers  


ORA-38612: FI item length cannot exceed half of one database block.

1 Answers  


ORA-02705: osnpol: polling of communication channel failed

1 Answers  


PLS-00713: attempting to instantiate a type that is NOT INSTANTIABLE

1 Answers  






ORA-12622: TNS:event notifications are not homogeneous

1 Answers  


ORA-31007: Attempted to delete non-empty container string/string

1 Answers  


ORA-24101: stopped processing the argument list at: string

1 Answers  


NID-00111: Oracle error reported from target database while executing string string

1 Answers  


ORA-32817: message system link string is not configured with a log queue for string

1 Answers  


ORA-12557: TNS:protocol adapter not loadable

1 Answers  


QSM-01522: a more optimal equivlanece than string was used to rewrite

1 Answers  


Categories