ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE
EXCHANGE PARTITION



ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION..

Answer / guest

Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE PARTITION 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-31216: DBMS_LDAP: PL/SQL - Invalid LDAP rdn.

1 Answers  


ORA-31494: could not activate a LogMiner session

1 Answers  


EXP-00039: export file string must be on a disk

1 Answers  


RMAN-03010: fatal error during library cache pre-loading

1 Answers  


ORA-00721: changes by release string cannot be used by release string

1 Answers  






ORA-02294: cannot enable (string.string) - constraint changed during validation

1 Answers  


ORA-30500: database open triggers and server error triggers cannot have BEFORE type

1 Answers  


RMAN-06564: must use the TO clause when the instance is started with SPFILE

1 Answers  


ORA-13606: the specified task parameter element string is out of range for parameter string.

1 Answers  


ORA-00094: %s requires an integer value

1 Answers  


PLS-00595: the TABLE operator is not allowed in this context

1 Answers  


TNS-04212: Trace Assistant Internal ERROR: NACOM Type Error

1 Answers  


Categories