You can specify up to a total of 1024K-1 partitions for a single-level partitioned tables, or subpartitions for a composite partitioned table. My goal is to exchange partitions from table 1 with corresponding partitions from table 2, including all subpartitions data.In Oracle Database 12c Release 2 (12.2) the SPLIT PARTITION and SPLIT SUBPARTITION operations on heap tables can be performed online so they don't block DML. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. One and only one partition or subpartition may be exchanged with one and only one nonpartitioned table in a single ALTER TABLE EXCHANGE PARTITION statement. A partition and exchange agreement is a legal contract between divorcing couples that outlines the terms of their property division and distribution.