Databases Reference
In-Depth Information
There are situations where you want to do a full transportable export and import of an
Oracle database. You might do this when moving an Oracle database from an older
computer system being retired to a new computer system. You might also use this ca‐
pability during the upgrade to a newer Oracle database release (where the older release
of Oracle is Oracle Database 11
g
Release 2 or later).
Similarly, where Oracle Database 12
c
is deployed, you might move an entire pluggable
database (PDB) in an Oracle multitenant container database (CDB) into another PDB.
You can also use Data Pump full transportable capabilities to move an Oracle database
that is not a CDB (from Oracle Database 11
g
Release 2 or later) into an Oracle PDB.
If your replication needs allow it, you can also do a partition exchange, where a single
partition of a table is moved to a target machine and then rapidly added to the table.
This feature has similar characteristics to using transportable tablespaces, but typically
requires a smaller amount of data, which reduces transmission times to the target
database.
