ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE
EXCHANGE SUBPARTITION



ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION..

Answer / guest

Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE SUBPARTITION statement have
different FOREIGN KEY constraints.

Action: Ensure that the two tables do not have FOREIGN KEY
constraints defined on any column or disable all FOREIGN KEY
constraints on both tables. Then retry the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29274: fixed-width multibyte character set not allowed for a URL

1 Answers  


DRG-12009: A new set of rules is requested to be added to your setup - continue?

1 Answers  


NNF-00110: no values exist

1 Answers  


QSM-02182: PCT is enabled through a join dependency

1 Answers  


ORA-01120: cannot remove online database file string

1 Answers  






ORA-29660: Unable to find the class defined in the EXTERNAL NAME clause

1 Answers  


ORA-09976: skxfqdini: Error Creating Port

1 Answers  


ORA-29659: SQLJ Object Type validation failed to get default connection

1 Answers  


ORA-12324: cannot use the ROM: link type on a private database link

1 Answers  


ORA-07759: slemtr: invalid destination

1 Answers  


ORA-29658: EXTERNAL NAME clause is not compatible with its supertype

1 Answers  


TNS-01016: change_password [<listener_name>]: changes the password of the listener

1 Answers  


Categories