When you specify WITHOUT VALIDATION for the exchange partition operation, this is normally a fast operation because it involves only data dictionary updates. You can specify up to a total of 1024K-1 partitions for a single-level partitioned tables, or subpartitions for a composite partitioned table.To exchange multiple partitions or subpartitions, use multiple ALTER TABLE EXCHANGE PARTITION statements. Ideally in the new schema, I'd like to create each new table as an empty table with the appropriate range and list partitions defined. This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax. This section describes how to perform partition and subpartition maintenance operations for both tables and indexes. My goal is to exchange partitions from table 1 with corresponding partitions from table 2, including all subpartitions data.