Database Reference
In-Depth Information
“Full transportable export/import” is the term used if the transportable
option on a full-mode export or import is used.
If you choose the transportable option, Data Pump will also include transportable
tablespace data movement. Transportable tablespace data movement, discussed in a previ-
ous chapter, can significantly improve the time of the import phase because Data Pump
doesn't have to load data and build indexes.
Naming the Import PDB
To tell Data Pump which PDB to use as a source or target, indicate the service name or
connect string of the PDB on the command line when using expdp or impdp . Establishing
a service name for a PDB was discussed in Chapter 12.
In this example, we'll invoke Data Pump to import data to a PDB named LNE6 :
impdp hr@LNE6 DIRECTORY=dpump_dir DUMPFILE=ncdb_expdat.dmp SCHEMAS=hr
The following are required when using Data Pump to move data into a CDB:
You must have the CDB_DBA role to administer a multitenant environment.
You must define a directory object within the PDB that you are exporting or importing
because DATA_PUMP_DIR doesn't work with PDBs. Use the CREATE DIRECTORY com-
mand in SQL*Plus to complete this task.
A non-CDB from a full database export of an Oracle Database version 11.2.0.2 and
earlier may be imported into a CDB or non-CDB in Oracle Database 12 c .
Oracle recommends that the source database be version 11.2.0.3 or later, because the
export file will contain more complete information about registered database options
and components. Set the Data Pump Export parameter VERSION=12 when creating a
full database export or a full transportable database export to generate a dump file
that is ready to import into Oracle Database 12 c .
File-based and network-based full transportable import requires the TRANSPORT_
DATAFILES=datafile_name parameter.
Additionally, network-based full transportable import requires the FULL=YES and
TRANSPORTABLE=ALWAYS parameters.
Using Data Pump to Migrate a Non-CDB to a CDB
In Chapter 12 we demonstrated how to use Data Pump to migrate a non-CDB Oracle 11 g
database to an Oracle Database 12 c PDB. Similarly, we can use Data Pump to migrate an
Oracle Database 12 c non-CDB into a PDB.
In Exercise 13.1, you will create a complete copy of the non-CDB as a full export using
Oracle Data Pump, which exports all objects and data. You will not use the Full Transportable
Search WWH ::




Custom Search