This chapter describes various aspects of creating and maintaining partitioned tables and indexes, and contains the following topics. When creating a partitioned table or index, you include a partitioning clause in the CREATE TABLE statement.When you specify WITHOUT VALIDATION for the exchange partition operation, this is normally a fast operation because it involves only data dictionary updates. Range Partitioning Maps data to partitions based on ranges of partition key values that you establish for each partition. 1)Exchange sub partitioning ALTER TABLE DEPARTMENT EXCHANGE SUBPARTITION SYS_SUBP7356 WITH TABLE TEMP_DEPARTMENT WITHOUT VALIDATION UPDATE GLOBAL INDEXES; This software is developed for general use in a variety of information management applications. Exchanging a Partition of a Reference Partitioned Table. Asif is an Oracle ACE and is OCP-Certified DBA, Forms Developer, and RAC Expert. He is a speaker at Oracle OpenWorld and All India Oracle User Group (AIOUG). This KM supports three partitioning strategies: range, hash, and list.
