Default: There is no default
Specifies a list of data files to be imported into the target database by a transportable-tablespace mode import, or by a table-mode or full-mode import if
TRANSPORTABLE=ALWAYS was set during the export. The data files must already exist on the target database system.
Syntax and Description
datafile_name must include an absolute directory path specification (not a directory object name) that is valid on the system where the target database resides.
At some point before the import operation, you must copy the data files from the source system to the target system. You can do this using any copy method supported by your operating stem. If desired, you can rename the files when you copy them to the target system (see Example 2).
If you already have a dump file set generated by a transportable-tablespace mode export, then you can perform a transportable-mode import of that dump file, by specifying the dump file (which contains the metadata) and the
TRANSPORT_DATAFILES parameter. The presence of the
TRANSPORT_DATAFILES parameter tells import that it is a transportable-mode import and where to get the actual data.
Depending on your operating system, the use of quotation marks when you specify a value for this parameter may also require that you use escape characters. Oracle recommends that you place this parameter in a parameter file, which can reduce the number of escape characters that might otherwise be needed on the command line.
TRANSPORT_DATAFILES parameter cannot be used in conjunction with the
Transportable import jobs cannot be restarted.
The following is an example of using the
TRANSPORT_DATAFILES parameter. Assume you have a parameter file,
trans_datafiles.par, with the following content:
DIRECTORY=dpump_dir1 DUMPFILE=tts.dmp TRANSPORT_DATAFILES='/user01/data/tbs1.dbf'
You can then issue the following command:
> impdp hr PARFILE=trans_datafiles.par
This example illustrates the renaming of data files as part of a transportable tablespace export and import operation. Assume that you have a data file named
employees.dat on your source system.
Using a method supported by your operating system, manually copy the data file named
employees.dat from your source system to the system where your target database resides. As part of the copy operation, rename it to
Perform a transportable tablespace export of tablespace
> expdp hr DIRECTORY=dpump_dir1 DUMPFILE=tts.dmp TRANSPORT_TABLESPACES=tbs_1
The metadata only (no data) for
tbs_1 is exported to a dump file named
tts.dmp. The actual data was copied over to the target database in step 1.
Perform a transportable tablespace import, specifying an absolute directory path for the data file named
> impdp hr DIRECTORY=dpump_dir1 DUMPFILE=tts.dmp TRANSPORT_DATAFILES='/user01/data/workers.dat'
The metadata contained in
tts.dmp is imported and Data Pump then assigns the information in the
workers.dat file to the correct place in the database.