Cloning/Creating a PDB

First, set your source and target datafile paths...

ALTER SESSION SET PDB_FILE_NAME_CONVERT='</seed path/>','</target path/>';

Then run the create command from the target root container...

CREATE PLUGGABLE DATABASE <New PDB Name>

                          ADMIN USER <Username>

                                IDENTIFIED BY <Password>

                          FROM <Source PDB[@dblink]>

Finally, Open the newly created database...

ALTER PLUGGABLE DATABASE <target pdb> OPEN;

NOTE: Creating a PDB is just cloning from the seed db.
[@dblink] is optional and used when creating PDB from existing PDB on another instance.
If using dblink, the link user should be an administrative user on the source PDB

Comments

Oracle General