Oracle Database 12c New Features

ORA-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table

ORA-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table


Cause:


The table in the EXCHANGE operation is either clustered or partitioned



Action:


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