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

Dropping a PDB Using SQL* Plus
Dropping the PDB is quite simple. Issue the DROP PLUGGABLE DATABASE command and the
SQL*Plus prompt, keeping in mind that you must have the SYSDBA or SYSOPER privileges as
previously described:
SQL> DROP PLUGGABLE DATABASE pdb2;
Pluggable database dropped.
SQL>
Notice that the DBCA and SQL*Plus do not exhibit the same behaviors. When you
unplug a PDB using the DBCA, it doesn't show up on the database list of available PDBs to
delete. When you unplug a PDB in SQL*Plus, it doesn't automatically delete the PDB; you'll
have to enter the SQL*Plus command to drop the PDB.
Migrating a Pre-12.1 Non-CDB Database to a CDB
In this section we will discuss how to take a non-CDB database created in a previous ver-
sion of Oracle Database and migrate it into a CDB. Basically there are two options. Either
upgrade the non-CDB to Oracle 12 c and plug the 12 c non-CDB into a CDB as a new PDB, or
use a migration tool to move the contents of the non-CDB into a CDB as a new PDB.
Since there is no direct upgrade from a pre-12.1 non-CDB to a CDB, the first option
would be to upgrade the non-CDB from a prior version to 12 c and then move the new
non-CDB into a PDB as described in previous sections. The second option, which we will
focus on for the remainder of this section, is to use Oracle Data Pump to move content
directly from the pre-12.1 non-CDB into a new PDB (see Exercise 11.3).
Performing an upgrade on a pre-12.1 non-CDB will result in a 12 c non-CDB.
To migrate the contents of a pre-12.1 non-CDB, you will need to create a
new 12 c CDB, and migrate the pre-12.1 non-CDB into a new PDB in the CDB.
Using Data Pump to Migrate a Non-CDB to a CDB
For this method we will use Oracle Data Pump to define a data set on a non-CDB from
a previous Oracle Database release, for example, Oracle Database 11 g . We will create an
empty PDB in a CDB and then use Oracle Data Pump to import the data set into the PDB.
We will create a complete copy of the non-CDB as a Full Transportable Export using
Oracle Data Pump, which exports all objects and data.
The Full Transportable dump file contains all objects in the database and is available
beginning with Oracle Database 11 g Release 2 (11.2.0.3). You can then use this dump file
to import into Oracle Database 12 c .