Category: OCM 12c Preparation

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

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

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

So, you need to know how to protect your database and how to resolve any kind of issue. How to protect is the easier part, you must ensure your environment will be prepared for a catastrophic event: Enable Archivelog Enable Flashback Add Supplemental Log Then perform a full backup of your CDB (including the PDBs) …

Continue reading

> This topic is pretty the same thing as we had in OCM 11g exam. But now as we have a container database scenario, we open more options. < So, create and manage database configuration files. What is this? Basically PFILE and SPFILE. So you may ask, do I need to know by heart and …

Continue reading