OCM 11g Preparation - Perform partition maintenance operations

The partition maintanence is as important as knowing create them.

Study in this topic all the kinds of partition operations, and be ready to access quickly the documentation to get or adapt codes:

• Partition operations: Adding / Coalescing / Dropping / Exchanging / Merging / Moving / Renaming / Splitting / Truncating
• Modifying Default Attributes
• Modifying Real Attributes of Partitions
• Modifying List Partitions: Adding / Dropping Values
• Modifying a Subpartition Template
• UPDATE INDEXES clause
• Do all the above for composite partitions
• Do all the above for subpartitions

Path to Documentation:

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

+1