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

The SYSAUX tablespace is not transportable. Also, if the SYSTEM tablespace
is locally managed, you can plug in a dictionary-managed tablespace, but
it will be read-only and cannot be made writable.
Step 3: Generate the Transportable Tablespace Set
As introduced earlier, 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. The transportable set must include all data files for each of the tablespaces to
transport. The remaining component of the transportable set is a Data Pump export file
that contains metadata about the transportable set. Here are the basic steps required to
generate the transportable set:
1. Make all of the tablespaces in the transportable set read-only.
2. Use Data Pump on the source system to specify which tablespaces are included in the
transportable set.
3. If converting to a different endian format, use the RMAN CONVERT command to convert
the files in a temporary location on the source system.
With these basic steps, we can show you a straightforward example. Remember, the
tablespaces are placed in read-only mode and remain read-only until the files have been
copied to the target or to their temporary location for endian conversion.
You must have the EXP_FULL_DATABASE role to export a transportable
tablespace. You must use a valid DIRECTORY in your Data Pump export
command.
First, place the tablespaces in the transportable set in read-only mode:
SQL> alter tablespace user_data read only;
Tablespace altered.
Now exit or “host” to the command line and execute the Data Pump export command:
SQL> host
C:\>expdp dumpfile=expdat.dmp DIRECTORY=DATA_PUMP_DIR
ORA-39123: Data Pump transportable tablespace job aborted
ORA-39187: The transportable set is not self-contained, violation list is
ORA-39908: Index SCOTT.FOO_INDX in tablespace USERS enforces primary constraints
of table SCOTT.FOO in tablespace USER_DATA.]
TRANSPORT_TABLESPACES= user_data
Export: Release 12.1.0.1.0 - Production on Monday, 21 October, 2013 20:40:19