Creating Oracle Multitenant Databases - OCP: Oracle Database 12c Administrator Certified Professional - page 526

Creating a Clone PDB Using a Remote PDB
There are options to this method as well, and it is also incredibly simple in its base form.
Verify that the source PDB is open in read-only mode, and then issue the CREATE PLUGGABLE
DATABASE command. In this example, CONT is the remote or source CDB, and NDLNE is the
local or target CDB:
SQL> create database link CONT
2 connect to system identified by system
3 using 'CONT';
Database link created.
SQL> connect sys/system@CONT
Connected.
SQL> alter pluggable database pdb1 open read only;
Pluggable database altered.
SQL> connect sys/system@NDLNE as sysdba
Connected.
SQL>
SQL> create pluggable database lne4 from pdb1@CONT;
Pluggable database created.
This assumes that LNE4 doesn't already exist within the current CDB and that PDB1 does
exist in the remote database.
Plugging an Unplugged PDB into a CDB
For this example we'll use an unplugged PDB from one CDB and plug it into another CDB
as a PDB with a new name. Consider using this method to quickly copy an unplugged PDB
from a development database to a test database:
1. In Step 1, shown in Figure 11.18, launch the DBCA and from the Database Operation
screen, choose Managed Pluggable Databases; then click Next.
2. In Step 2, choose Create A Pluggable Database; then click Next, as shown in Figure 11.19.
3. In Step 3, choose the target CDB that you want to plug the new PDB into. Enter the
credentials for a user in the target database who has SYSDBA privileges, and then click
Next, as shown in Figure 11.20.
4. In Step 4, since you're using an unplugged database from another CDB, you'll choose
to create the PDB from a PDB file set, as shown in Figure 11.21. Click the Browse but-
ton to select the files that have been previously unplugged from other CDBs on the
local system. Click Next when you have selected the correct XML file, and the associ-
ated DFB filename will be filled in for you.