Creating Pluggable Databases in Oracle

Back to: Oracle DBA Tutorials

Creating Pluggable Databases in Oracle:

In this article, I am going to discuss Creating Pluggable Databases in Oracle with Examples. We have many methods in Oracle to create a pluggable database.

Methods to Create PDBs:

• Create a PDB by using the seed.
• Create a PDB from a non-CDB (Not part of this course)
• Clone an existing PDB or non-CDB
• Plug an unplugged PDB into a different CDB.
• Relocate a PDB to a different CDB (Not part of this course)
• Create a PDB as a proxy PDB. (Not part of this course)

Topics Discussed:

Create a PDB by using the seed: We already discussed a pluggable database called SEED. It is like a template. We use this seed database to create multiple pluggable databases. Oracle makes life easy by creating the seed database.

Create a PDB from a non-CDB: We can configure an oracle 12c,18c, and 19c to be a non-container database. It removes the relation of the container and the pluggable database.

Clone an existing PDB or non-CDB: We have a pluggable database that runs an application. So, we can close this pluggable database to another pluggable database.

Plug an unplugged PDB into a Same Container: We don’t have a multiple-container database. So, we will discuss how to unplug a PDB and plug it into the same container database.

These topics are part of the Oracle certification exam.

Tools to Create PDBs:

• SQL*Plus
• SQL Developer
• Enterprise Manager Cloud Control
• DBCA

This is the overview to create a pluggable database. In the further topics, we will discuss the creation of the pluggable database. In the next article, I am going to discuss Creating Pluggable Database from SEED in Oracle with Examples.