How to Convert an Oracle 12c Database to a Multitenant Pluggable Database (PDB)
Learn how to convert a Non-CDB Oracle 12c Database to a 12c Pluggable Database (PDB), i.e. how to plug in a “normal” (non-CDB) database into a 12c Container Database (CDB).
Oracle Certified Master John Watson, SkillBuilders Director of Oracle Database Services, provides an outstanding overview of the conversion process and method and provides a detailed demonstration.
This is the second tutorial in the series on 12c Multitenant database – see what-is-12c-multi-tenant-cdb-pdb-database for the first tutorial in the series.
For additional information on multi-tenant architecture an benefits , also see http://www.oracle.com/technetwork/database/multitenant/overview/index.html.
This free Oracle 12c Multitenant tutorial is segmented into four separate lessons:
- Agenda (1:20)
(click to read the Transcript)
A brief introduction to the tutorial agenda, what we covered in the first Multitenant agenda and what we’ll cover in future multitenant tutorials. - The Demonstration Environment (2:05)
John shows us his demo environment, ie his “regular” non-CDB database and his 12c CDB database. - The Conversion Process Explained (3:02)
In this lesson John describes the process and precise method to do the conversion. - Conversion Demonstration (10:26) (click on video below)
The pièce de résistance! John demonstrates plugging in a 12c database into a mutlitenant Container Database (CDB). You’ll see examples of execute dbms_pdb to create the XML file, noncdb_to_pdb.sql to convert the data dictionary to work as a pluggable container and the “create pluggable database” command, and more.
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.