This section contains the following topics:
Oracle Database Administrator's Guide for information about managing tables
Oracle Database SQL Language Reference for the exact syntax of the partitioning clauses for altering partitioned tables and indexes, any restrictions on their use, and specific privileges required for creating and altering tables
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
UNUSABLE status is left unchanged.
Only indexes or index partitions with
USABLE status are updated by subsequent DML.