Oracle Error ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION

Oracle Error Message

ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION

Reason for the Error

The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE SUBPARTITION are of different type or size

Solution

Ensure that the two tables have the same number of columns with the same type and size.