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

RMAN-06719: file "string" (string bytes) restrieved from catalog

1 Answers  


KUP-03013: OCI error getting database column scale.

1 Answers  


ORA-30155: An I/O Error occured during an OCIFile function call

1 Answers  


ORA-31467: no column found in the source table

1 Answers  


PLS-00254: OUT and IN/OUT modes cannot be used in this context

1 Answers  






ORA-13787: missing SQL profile for statement object "string" for tuning task "string"

1 Answers  


SQL*Loader-00294: invalid name % specified in TREAT AS clause

1 Answers  


AMD-00138: level names parameter not null or defaulted

1 Answers  


ORA-09751: pw_attachPorts: server call pws_attach failed.

1 Answers  


ORA-16785: The database is not in ARCHIVELOG mode

1 Answers  


ORA-38485: invalid object type for the user-defined function

1 Answers  


PROC-00007: Cannot perform cluster registry operation because key handle is invalid.

1 Answers  


Categories