This topic is very similar with the one we had for OCM 11g but here we need to consider not only all the partitioned methods that we had in 11g but also the new features regarding partitioned table in 12c.
So practice here:
- Basic Partitioning Strategies: RANGE, LIST and HASH.
- Advanced Partitioning Strategies: REFERENCE, INTERVAL, SYSTEM and VIRTUAL COLUMN-BASED.
- Composite Partitions (all the combinations)
- Multicolumns Partitions (This is not composite!)
- Creating Partitioned Index-Organized Tables
Plus:
- Partition Maintenance Operations on Multiple Partitions
- Partial Indexes for Partitioned Tables
- Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION
- Interval-Reference Partitioning
- Cascade Functionality for TRUNCATE PARTITION and EXCHANGE PARTITION
- Online Move Partition
Path to Documentation:
Database SQL Language Reference -> CREATE TABLE
VLDB and Partitioning Guide -> 4 Partition Administration -> Creating Partitions – (Good for copy paste examples during the exam)
VLDB and Partitioning Guide -> 2 Partitioning Concepts
Click here to go back to the Main OCM 12c Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
1 comments
Thank you Rodrigo