Default: There is no default
Syntax and Description
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.
PARFILE parameter cannot be specified within a parameter file.
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
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
.dmp in the location pointed to by
dpump_dir1. The log file for the job will also be written to