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

SQL-02136: Invalid NCHAR character set id

1 Answers  


ORA-07204: sltln: name translation failed due to lack of output buffer space.

2 Answers  


ORA-30038: Cannot perform parallel insert on non-partitioned object

1 Answers  


NID-00305: Datafile string - already changed

1 Answers  


NZE-29037: No certificate is present

1 Answers  






PROC-00029: Error in logging layer

1 Answers  


RMAN-03091: Finished string at string

1 Answers  


ORA-07635: smsdbp: $SETPRT failure

1 Answers  


ORA-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns

1 Answers  


ORA-16005: database requires recovery

1 Answers  


RMAN-06606: RMAN configuration parameters are successfully reset to default value

1 Answers  


ORA-01940: cannot drop a user that is currently connected

1 Answers  


Categories