Default: There is no default
Purpose
Syntax and Description
PARFILE=[directory_path]file_name
A parameter file allows you to specify Data Pump parameters within a file, and then that file can be specified on the command line instead of entering all the individual commands. This can be useful if you use the same parameter combination many times. The use of parameter files is also highly recommended if you are using parameters whose values require the use of quotation marks.
A directory object is not specified for the parameter file because unlike dump files, log files, and SQL files which are created and written by the server, the parameter file is opened and read by the impdp
client. The default location of the parameter file is the user's current directory.
Within a parameter file, a comma is implicit at every newline character so you do not have to enter commas at the end of each line. If you have a long line that wraps, such as a long table name, enter the backslash continuation character (\) at the end of the current line to continue onto the next line.
Restrictions
The PARFILE
parameter cannot be specified within a parameter file.
Example
The content of an example parameter file, hr_imp.par
, might be as follows:
TABLES= countries, locations, regions DUMPFILE=dpump_dir2:exp1.dmp,exp2%U.dmp DIRECTORY=dpump_dir1 PARALLEL=3
You could then issue the following command to execute the parameter file:
> impdp hr PARFILE=hr_imp.par
The tables named countries
, locations
, and regions
will be imported from the dump file set that is created when you run the example for the Export DUMPFILE
parameter. (See "DUMPFILE".) The import job looks for the exp1.dmp
file in the location pointed to by dpump_dir2
. It looks for any dump files of the form exp2
nn
.dmp
in the location pointed to by dpump_dir1
. The log file for the job will also be written to dpump_dir1
.