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

Oracle Error Message

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

Reason for the Error

The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE PARTITION statement have CHECK constraint defined on them.

Solution

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