Duplicating Databases

Duplicating PDBs

To duplicate the PDB pdb1 to the CDB cdb1, use the following command:

DUPLICATE DATABASE TO cdb1 PLUGGABLE DATABASE pdb1;

To duplicate the PDBs pdb1, pdb3, and pdb4 to the database cdb1, use the following command:

DUPLICATE DATABASE TO cdb1 PLUGGABLE DATABASE pdb1,pdb3,pdb4;

To duplicate all the PDBs in the CDB, except the PDB pdb3, use the following command:

DUPLICATE DATABASE TO cdb1 SKIP PLUGGABLE DATABASE pdb3;