OCM 11g Preparation - Maintain indexes on a partitioned table

Now that you know how to manage the partitions, start working with their indexes:

• Rebuilding Global Index Partitions
  • Rebuild each partition by issuing the ALTER INDEX ... REBUILD PARTITION statement (you can run the rebuilds concurrently).
  • Drop the entire global index and re-create it. This method is more efficient because the table is scanned only one time.
• Rebuilding Local Index Partitions
  • ALTER INDEX ... REBUILD PARTITION/SUBPARTITION
  • ALTER TABLE ... MODIFY PARTITION/SUBPARTITION ... REBUILD UNUSABLE LOCAL INDEXES
• When managing the partitions, check if you might use UPDATE GLOBAL INDEXES

Path to Documentation:

Database SQL Language Reference -> ALTER INDEX
VLDB and Partitioning Guide -> 4 Partition Administration -> Maintaining Partitions (Rebuilding Index Partitions) - (Good for copy paste examples during the exam)

+1