UPDATE INDEXES clause support operations - Oracle Indexes and Partitioned Tables

Q.  Which of the following operations support the UPDATE INDEXES clause?
- Published on 04 Aug 15

a. ADD PARTITION | SUBPARTITION, MERGE PARTITION | SUBPARTITION
b. COALESCE PARTITION | SUBPARTITION, MOVE PARTITION | SUBPARTITION
c. DROP PARTITION | SUBPARTITION, SPLIT PARTITION | SUBPARTITION
d. EXCHANGE PARTITION | SUBPARTITION, TRUNCATE PARTITION | SUBPARTITION
e. All mentioned above

ANSWER: All mentioned above
 

    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


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)