In MySQL 5.7, it is possible to exchange a table partition or subpartition with a table using ALTER TABLE pt EXCHANGE PARTITION p WITH TABLE nt. When creating a partitioned table or index, you include a partitioning clause in the CREATE TABLE statement.This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax. Before the exchange, the target partition is populated in the IM column store. After the exchange, the source table remains populated in the IM column store. Subpartition By: The partitioning type to be used to create subpartitions within each range partition. , software developed using this specification may claim compliance. Oracle Corporation, 500. Oracle Parkway, Redwood City, CA 94065. Partition-Based Parallelism.