ORA-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION

ORA-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE
PARTITION

Question Posted / guest

1 Answers
5797 Views
I also Faced
E-Mail Answers

ORA-14118: CHECK 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 CHECK
constraint defined on them.

Action: Ensure that the two tables do not have CHECK
constraint defined on any column

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27125: unable to create shared memory segment

1 Answers

ORA-06136: NETTCP: error during connection handshake

1 Answers

AMD-00149: Custom Measure to delete "string" does not exist in Workspace "string"

1 Answers

ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.

1 Answers

ORA-30161: A system error occurred during the OCIFile function call

1 Answers

RMAN-06470: DEVICE TYPE is supported only when automatic channels are used

1 Answers

RMAN-03037: Spooling started in log file: string

1 Answers

ORA-09715: orasrv: cannot obtain puname

1 Answers

ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an object type

1 Answers

ORA-30346: hierarchy name must be unique within a dimension