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-24170: %s.string is created by AQ, cannot be dropped directly

1 Answers  


ORA-00972: identifier is too long

1 Answers  


ORA-24375: Cannot use V6 syntax when talking to a V8 server

1 Answers  


ORA-13423: invalid cell coordinate parameter

1 Answers  


NCR-01007: NCRS: Operation is not supported in a given mode.

1 Answers  






ORA-06102: NETTCP: cannot allocate context area

1 Answers  


ORA-13353: ELEM_INFO_ARRAY not grouped in threes

1 Answers  


LFI-00143: Unable to delete non-existent file string.

1 Answers  


QSM-02123: subquery and UNION mv's must be primary key mv's

1 Answers  


ORA-32582: table function with left correlation to a table cannot also be left outer-joined to the table

1 Answers  


ORA-32806: value for string is too long, maximum length is string

1 Answers  


ORA-06777: TLI Driver: error reading parms

1 Answers  


Categories