Expand To Show Full Article
Oracle Error ORA-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION - Developer Publish

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

Oracle 23 Views 0 Min Read

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

Tags: