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. You can specify up to a total of 1024K-1 partitions for a single-level partitioned tables, or subpartitions for a composite partitioned table.This chapter describes various aspects of creating and maintaining partitioned tables and indexes, and contains the following topics. This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax. In a composite partitioned table, only subpartitions have storage clauses and tablespaces. Partitions are just logical. A partition action is a legal remedy used when coowners of a property cannot come to an agreement on how to divide or manage the property. This reference contains a complete description of the Structured Query Language. (SQL) used to manage information in an Oracle Database.