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-39146: schema "string" does not exist

1 Answers  


NNL-01074: ApplTable Index: number

1 Answers  


TNS-00001: INTCTL: error while getting command line from the terminal

1 Answers  


ORA-36992: (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.

1 Answers  


ORA-28117: integrity constraint violated - parent record not found

1 Answers  






QSM-00766: a SQL statement is required for the current workload operation

1 Answers  


ORA-30749: column string not enabled to store objects of type string.string

1 Answers  


ORA-30929: ORDER SIBLINGS BY clause not allowed here

1 Answers  


ORA-09213: slgfn: error fabricating file name

1 Answers  


PLS-00151: Expression or Variable is an illegal type to PLS/QL: string

1 Answers  


ORA-27548: Unable to unprepare IPC buffer

1 Answers  


ORA-32828: Messaging Gateway agent must be running

1 Answers  


Categories