Jun 19

OCM 12c Preparation - Configure the database to retrieve all previous versions of the table rows

For OCM11g, this topic was written as Perform various recovery operations using Flashback technology but it's pretty the same thing. Here, you must be able and focus in all possible ways to get back the rows of a table in all possible scenarios. We usually think on flashback technology but in 12c we also have the …

Continue reading

Jun 19

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 …

Continue reading

Jun 18

OCM 12c Preparation - Create a plugged-in tablespace by using the transportable tablespace feature

Transporting whole tablespaces is a very good and practical way to move data from one Database to another. Oracle will generate a small dump with the object’s metadata and all you need to do is copy the datafiles and dumps to the new system. In this topic, practice: Check if Transport is possible with DBMS_TTS.TRANSPORT_SET_CHECK …

Continue reading

Jun 14

OCM 12c Preparation - Oracle Database 12c: OCM Exam Preparation Workshop

As I said in previous sections, one course that I do recommended for this exam is the "Oracle Database 12c: OCM Exam Preparation Workshop". So here I will list all Course Sections and Objectives retrieved from Oracle Website and that will probably help also to serve as a topics guide: Workshop Objectives: Describe the multitenant architecture Establish …

Continue reading

Jun 13

OCM 12c Preparation - Modify materialized views

So, for the OCM 12c Upgrade Exam, for this topic I recommend to first revise all the materialized view features studied for OCM 11g. However, as the topic here is named "Modify" and not "Create", you must take special attention in 12c New Features, such as: Synchronous Refresh Out-of-Place Refresh And don't forget to review all the other Materialized …

Continue reading