UPDATE INDEXES clause support operations - Oracle Indexes and Partitioned Tables

Discussion

• Nirja Shah   -Posted on 28 Sep 15
  - Optional clauses for local indexes let you specify physical and storage characteristics for updated local indexes and their partitions.
  
  - You can specify physical attributes, tablespace storage, and logging for each partition of each local index.
  
  - Alternatively, you can specify only the PARTITION keyword and let the database update the partition attributes as follows:
  
  - For operations on a single table partition (such as MOVE PARTITION and SPLIT PARTITION), the corresponding index partition inherits the attributes of the affected index partition.
  
  - The database does not generate names for new index partitions, so any new index partitions resulting from this operation inherit their names from the corresponding new table partition.
  
  - For MERGE PARTITION operations, the resulting local index partition inherits its name from the resulting table partition and inherits its attributes from the local index.
  
  - For a composite-partitioned index, you can specify tablespace storage for each subpartition.
  
  - The following operations support the UPDATE INDEXES clause:
  
  - ADD PARTITION | SUBPARTITION
  - COALESCE PARTITION | SUBPARTITION
  - DROP PARTITION | SUBPARTITION
  - EXCHANGE PARTITION | SUBPARTITION
  - MERGE PARTITION | SUBPARTITION
  - MOVE PARTITION | SUBPARTITION
  - SPLIT PARTITION | SUBPARTITION
  - TRUNCATE PARTITION | SUBPARTITION

➨ Post your comment / Share knowledge