Default: There is no default
Purpose
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
TRANSPORT_DATAFILES=datafile_name
The 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.
Restrictions
The TRANSPORT_DATAFILES
parameter cannot be used in conjunction with the QUERY
parameter.
Transportable import jobs cannot be restarted.
Example 1
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 workers.dat
.
Perform a transportable tablespace export of tablespace tbs_1
.
> 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 workers.dat
:
> 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.