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

exeRCiSe 11.2 (continued)
Pluggable database created.
SQL>
After you create a PDB using SQL*Plus, open the new PDB (in read/write mode) to
complete the integration of the new PDB into the CDB. Once the database is open and
control is returned at the command prompt, the new PDB is ready to use.
SQL> connect sys/system@CONT as sysdba
Connected.
SQL>
SQL>
SQL> alter pluggable database pdb3 open;
Pluggable database altered.
SQL>
Creating a PDB from a Clone
In this section we will demonstrate two methods for creating a clone of a PDB. The first option
is to create a PDB clone locally, or within the existing CDB. The second option is to create
a PDB as a clone of a remote PDB, or a PDB from another CDB. The CREATE PLUGGABLE
DATABASE statement copies the source PDB files to a new location and creates the target PDB.
Creating a Clone PDB Using a Local PDB
While there are options to this method, it is 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:
SQL> alter pluggable database pdb1 open read only;
Pluggable database altered.
SQL> create pluggable database lne1 from pdb1;
Pluggable database created.
This assumes, of course, that LNE1 doesn't already exist within the current CDB and that
PDB1 does.