Create Pluggable Database (PDB) from scratch in Oracle 19c / 23ai

 Creating pluggable database (PDB) from scratch means creating from Seed PDB (PDB$SEED) as a template. When you create a new PDB from scratch, Oracle copies all DB files from SEED PDB (PDB$SEED) to the datafile directory of the new PDB. Then the metadata information is also copied from the Seed PDB to the new PDB

Basic Syntax to create pluggable database (PDB) from scratch:

CREATE PLUGGABLE DATABASE pdb_name

  ADMIN USER admin_username IDENTIFIED BY password

  ROLES = (DBA)

  FILE_NAME_CONVERT = ('/path/to/cdb/pdbseed/', '/path/to/cdb/pdb_name/')

  ;

You must be connected to the Container Database (CDB) with the appropriate privilege to create the PDB.

Simple command with no optional clause to create PDB from SEED PDB:

CREATE PLUGGABLE DATABASE pdb19c1 ADMIN USER pdb19c1adm IDENTIFIED BY pdb19c1pwd;

When no file name convert clause is used in the create command, the datafile directory of the new PDB is decided from the parameter db_create_file_dest or pdb_file_name_convert (Listed in the order of preference)

Watch the below video for a detailed tutorial & demo on this topic.

https://youtu.be/3nMeStznhjU

=======================================================================

** Email to info@shreyantech.com to get the Tip of the Day in your mailbox.