Oracle Error ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

Oracle Error Message

ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

Reason for the Error

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

Solution

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