When creating a partitioned table or index, you include a partitioning clause in the CREATE TABLE statement. This chapter describes various aspects of creating and maintaining partitioned tables and indexes, and contains the following topics.My goal is to exchange partitions from table 1 with corresponding partitions from table 2, including all subpartitions data. Range Partitioning Maps data to partitions based on ranges of partition key values that you establish for each partition. This software is developed for general use in a variety of information management applications. First we create a sample schema as our starting point. -- Create and populate a small lookup table. Loading (ETL) processes.