When you specify WITHOUT VALIDATION for the exchange partition operation, this is normally a fast operation because it involves only data dictionary updates. 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. One exchange operation. Exchange (clear) out of target bottom-up. 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. First we create a sample schema as our starting point. -- Create and populate a small lookup table.