PARFILE

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=parameter_file_name

It is recommend that a parameter file be used if any parameter values contain quotation marks.

Note:

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.

Restrictions

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 hr TABLE=employees PARFILE=daily_report.par
Password: 
```

Example

Suppose you have the following parameter file, test.par:

table=employees
data='mydata*.dat'
enclosed_by='"'

Any fields enclosed by double quotation marks, in any data files that match mydata*.dat, are loaded into table employees when you execute the following command:

> sqlldr hr PARFILE=test.par
Password: