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)
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 Developer
- Enterprise Manager Cloud Control
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.