ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION
Cause: The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE SUBPARTITION are of different type or size
Action: Ensure that the two tables have the same number of columns with the same type and size.
ORA-14278 columntypeor size mismatch in EXCHANGE SUBPARTITION means that the columns to exchange subpartitions have different data types or lengths.
Official Explanation:
ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION
Cause: Column type or sizes are difference between two partitions or subpartitions from which exchange subpartition is taking place.
Common Cases:
The error occurs when you try to exchange two subpartitions of a different type or size, such as a table subpartition with an index subpartition, or two different partitions with different column types.
Normal Handling:
To resolve the issue, make sure that the columns to exchange subpartitions have the same data types and lengths, and then try to exchange the partitions.