Managing Database Resources - OCP: Oracle Database 12c Administrator Certified Professional - page 466

Managing Transportable Tablespaces
The transportable tablespace feature allows you to copy or move a tablespace from one
database to another. Using transportable tablespaces is faster than copying rows or using
export/import or unload/load. With Oracle 10 g or higher, it is possible to transport
tablespaces across some but not all platforms. Transportable tablespaces are useful for,
but not limited to, the following:
■ Database migrations
■ Sharing tablespaces with other database users (for example, remote customers)
■ Tablespace point-in-time recovery (TSPITR)
■ Archiving data from one database to another
■ Exporting and importing partitions
Transporting a tablespace is straightforward, but there are caveats and limitations. You
can use Enterprise Manager, or you can use SQL*Plus and the OS command line. We will
take you through the basic process and list the major considerations.
The first step is to determine what will be transported. If your intent is to transport
objects that exist in only one tablespace and have no dependencies in other tablespaces, then
the process is simplified. If, however, you intend to transport a set of objects that are spread
across multiple tablespaces or have dependencies on objects in other tablespaces, then the
task becomes slightly more complex.
Transportable Tablespace Sets
A transportable tablespace set is a self-contained group of tablespaces that encapsulate the
objects that you wish to transport from one database to another. For example, if you wish to
transport several tables that reside in different tablespaces, then you would include each of the
tablespaces in the tablespace set. If you wish to transport a partitioned table and the different
partitions are in different tablespaces, then you would need to include each of the tablespaces
in the tablespace set.
We'll discuss tablespace sets in detail and show examples a bit later.
Manually Transporting a Tablespace
In this section, we will demonstrate how to manually transport a tablespace using a combi-
nation of SQL*Plus, the OS command line, and Oracle Data Pump.
The basic steps are as follows:
1. Check compatibility and endian format.
2. Choose the transportable tablespace set.
3. Generate the transportable tablespace set.
4. Transport the tablespace set.
5. Import the tablespace set.