Oracle Database 12c New Features

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

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


Cause:


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



Action:


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