Maintenance Operations for Partitioned Tables and Indexes

This section describes how to perform partition and subpartition maintenance operations for both tables and indexes.

This section contains the following topics:

See Also:


The following sections discuss maintenance operations on partitioned tables. Where the usability of indexes or index partitions affected by the maintenance operation is discussed, consider the following:

  • Only indexes and index partitions that are not empty are candidates for being marked UNUSABLE. If they are empty, the USABLE/UNUSABLE status is left unchanged.

  • Only indexes or index partitions with USABLE status are updated by subsequent DML.