Oracle Utilities - OCP: Oracle Database 12c Administrator Certified Professional - page 590

option. You will create an empty PDB in a CDB and then use Oracle Data Pump to import the
dataset into the PDB.
Data Pump error
Data Pump does not support any CDB-wide operations in Oracle Database 12 c Release
1 (12.1). If you are connected to CDB$ROOT or PDB$SEED and attempt to utilize Data Pump,
you'll get an error message, as shown here:
ORA-39357: WARNING: Oracle Data Pump operations are not typically needed when
connected to the root or seed of a container database.
e xeRCiSe 13.1
Using Data Pump to Migrate a Non-CDB into a PDB
In this exercise, you will use Data Pump to export a non-CDB database that is in an Oracle
12 c database and use Data Pump import to move the content into a PDB that is in a CDB.
1. Create a new CDB target, or utilize an existing CDB. In this example, we'll use our
CONT CDB.
2. Create a new PDB from the PDB$SEED . In this example, we'll call it LNE6 . After you've
created the PDB, remember to open it in read-write mode before attempting to import
into it. Grant appropriate privileges to the Admin user, and create a directory for Data
Pump to use with the PDB. Create the target schema and target tablespaces as needed.
Also update the tnsnames.ora file to include a new service for the new PDB.
SQL> CREATE PLUGGABLE DATABASE lne6
2 ADMIN USER lne6_admin IDENTIFIED BY system06
3 /
Pluggable database created.
SQL> ALTER PLUGGABLE DATABASE lne6 OPEN;
Pluggable database altered.
SQL> ALTER SESSION SET CONTAINER=lne6;
Session altered.
SQL> GRANT DBA, IMP_FULL_DATABASE TO lne6_admin;
Grant succeeded.
SQL> CREATE DIRECTORY dpump_dir AS 'c:\temp\';
Directory created.