When creating a partitioned table or index, you include a partitioning clause in the CREATE TABLE statement. Range Partitioning Maps data to partitions based on ranges of partition key values that you establish for each partition.My goal is to exchange partitions from table 1 with corresponding partitions from table 2, including all subpartitions data. 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. The software described in this guide is furnished under a software license or nondisclosure agreement. In the PARTITION and SUBPARTITION clauses, you cannot specify a bind variable for the partition or subpartition name. Example. An Oracle developer and DBA since 1987, he has implemented large-scale transaction processing systems and data warehouses.