Default: There is no default.
Purpose
The PARFILE
parameter specifies the name of a file that contains commonly used command-line parameters.
Syntax and Description
PARFILE=file_name
Instead of specifying each parameter on the command line, you can simply specify the name of the parameter file. For example, a parameter file named daily_report.par
might have the following contents:
USERID=scott CONTROL=daily_report.ctl ERRORS=9999 LOG=daily_report.log
For security reasons, you should not include your USERID
password in a parameter file. SQL*Loader will prompt you for the password after you specify the parameter file at the command line, for example:
sqlldr PARFILE=daily_report.par
Password: password
Restrictions
Although it is not usually important, on some systems it may be necessary to have no spaces around the equal sign (=) in the parameter specifications.
Example
See the example in the Syntax and Description section.