How to Convert an Oracle 12c Database to a Multitenant Pluggable Database (PDB) | The Demonstration Environment

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:

1. 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.
2. The Demonstration Environment (2:05) (click on video below)
   John shows us his demo environment, ie his “regular” non-CDB database and his 12c CDB database.
3. The Conversion Process Explained (3:02)
   In this lesson John describes the process and precise method to do the conversion.
4. Conversion Demonstration (10:26)
   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.

Date: Aug 22, 2016

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.