Transportable Tablespace Mode

A transportable tablespace import is specified using the TRANSPORT_TABLESPACES parameter. In transportable tablespace mode, the metadata from a transportable tablespace export dump file set or from another database is loaded. The datafiles specified by the TRANSPORT_DATAFILES parameter must be made available from the source system for use in the target database, typically by copying them over to the target system.

This mode requires the IMP_FULL_DATABASE role.

The figure below shows the directory name and the dump file name for the import file.

Figure. Parameters for the Import.

First Page: Oracle 10g Free Training - Using Data Pump Import