Oracle Error ORA-14276: EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table

Oracle Error Message

ORA-14276: EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table

Reason for the Error

The table in the ALTER TABLE EXCHANGE SUBPARTITION operation is either clustered or partitioned

Solution

Ensure that the table with which the subpartition is being exchanged for is not partitioned or clustered.