ORA-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns

You are here: Home // Oracle 11g // ORA-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns

Cause: The two tables specified in the ALTER TABLE EXCHANGE SUBPARTITION have different number of columns See the solution below.

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

Database version: Oracle 11g Release 2 (11.2)