In the next 2-3 posts we are going to see all the methods used to create Pluggable Database

There are following methods available to create Pluggable Database :

  • Clone a regular PDB
  • Create remote pdb using dblink
  • Create a regular pdb to an application PDB
  • Unplug and Plug a non-CDB
  • Unplug and plug a regular PDB
  • Unplug and plug an application container

1. Clone a regular PDB :

We can simply clone a regular Pluggable Database to create a new pluggable database.

I have one PDB created named PDBB121 and I want to create new PDB which should be a clone of PDB121 database.

Step 1: Connect to the CDB database

Step 2: Check database which you want to create exist

Step 3: Clone database using create the pluggable database

As I don’t have OMF enabled I need to pass the FILE_NAME_CONVERT parameter.

2.Create remote pdb using dblink

Create Pluggable Database using dblink

3. Clone a regular pdb to an application PDB :

Convert Regular PDB to Application PDB

4.Unplug and Plug a non-CDB

Plugging Non-CDB to CDB

5.Unplug and plug a regular PDB

Step 1: Connect to CDB :

Step 2: shutdown pluggable database which you want to unplug and plug to another cdb.

Step 3: Unplug database using the following statement

Step 4: Connect to Container database where you want to plug the pdb1 database.

Step 5: Create a pluggable database using the .xml file

6.Unplug and plug an application container

Unplug and plug application container

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.