When creating a partitioned table or index, you include a partitioning clause in the CREATE TABLE statement. One exchange operation.Exchange (clear) out of target bottom-up. This chapter describes various aspects of creating and maintaining partitioned tables and indexes, and contains the following topics. 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. 1)Exchange sub partitioning ALTER TABLE DEPARTMENT EXCHANGE SUBPARTITION SYS_SUBP7356 WITH TABLE TEMP_DEPARTMENT WITHOUT VALIDATION UPDATE GLOBAL INDEXES; 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. Redwood City, CA 94065.