OCM 12c Preparation - Create partitioned tables

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

    • Levin Karuoya on September 29, 2018 at 14:41
    • Reply

    Thank you Rodrigo

Leave a Reply

Your email address will not be published.