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.
About the Author: Pranaya Rout
Pranaya Rout has published more than 3,000 articles in his 11-year career. Pranaya Rout has very good experience with Microsoft Technologies, Including C#, VB, ASP.NET MVC, ASP.NET Web API, EF, EF Core, ADO.NET, LINQ, SQL Server, MYSQL, Oracle, ASP.NET Core, Cloud Computing, Microservices, Design Patterns and still learning new technologies.