Database Reference
In-Depth Information
Summary
In this chapter, you learned about the Oracle Database 12 c multitenant architecture, its pri-
mary components, advantages of the multitenant architecture, and use-cases for the option.
You saw how to provision pluggable databases and how to create the multitenant container
database environment.
You learned how to create container databases using the Database Configuration Assistant
and SQL*Plus. You discovered how to create pluggable databases using various methods and
various sources: from the seed database, from non-CDBs, and from existing PDBs.
You also learned how to unplug and drop existing PDBs using different tools. You
were introduced to migrating pre-Oracle Database 12 c (non-CDB databases) into a CDB
environment using Oracle Data Pump.
Exam Essentials
Know the fundamental components of the Oracle Database 12 c multitenant architecture.
Make sure you understand what makes the multitenant architecture unique and what differ-
entiates a CDB from a non-CDB.
Know how to explain the advantages of the Oracle multitenant architecture. Know the
technical and administrative advantages of the multitenant architecture over the basic
single-tenant architecture.
Know the different methods to provision pluggable databases. Know the different sources
and methods used to create a new PDB.
Demonstrate how to create a CDB. Understand the prerequisites to creating a container
database. Know how to create a CDB using the DBCA or SQL*Plus.
Understand how to create a PDB. Know what methods are available to create a PDB and
what nuances exist when creating PDBs from different sources.
Know how to unplug and delete a PDB. Know the difference between unplugging and
dropping a PDB. Know what to do once you've unplugged a PDB and want to clean up the
residual files.
Know how to migrate pre-12.1 non-CDB databases. Remember that all databases
created in previous versions of the database are referred to as non-CDBs. Know how
to migrate non-CDBs forward using Data Pump and the techniques described earlier to
create CDBs and PDBs.
Search WWH ::




Custom Search