4 Partition Administration

Partition administration is an important task when working with partitioned tables and indexes. This chapter describes various aspects of creating and maintaining partitioned tables and indexes, and contains the following topics:

• Creating Partitions

• Maintaining Partitions

• Dropping Partitioned Tables

• Partitioned Tables and Indexes Example

• Viewing Information About Partitioned Tables and Indexes

Note:

Before you attempt to create a partitioned table or index, or perform maintenance operations on any partitioned table, it is recommended that you review the information in Chapter 2, "Partitioning Concepts".