Exchanging table partitions is useful to get data quickly in or out of a partitioned table. To exchange multiple partitions or subpartitions, use multiple ALTER TABLE EXCHANGE PARTITION statements.One exchange operation. Exchange (clear) out of target bottom-up. 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. My goal is to exchange partitions from table 1 with corresponding partitions from table 2, including all subpartitions data. 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 article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax. This chapter describes various aspects of creating and maintaining partitioned tables and indexes, and contains the following topics.