Oracle Error ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION

Oracle Error Message

ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION

Reason for the Error

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

Solution

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