Oracle7 Server Utilities

Specifying Command-Line Parameters in the Control File

The OPTIONS statement is useful when you typically invoke a control file with the same set of options, or when the number of arguments makes the command line very long. The OPTION statement precedes the LOAD DATA statement.

OPTIONS

This keyword allows you to specify runtime arguments in the control file, rather than on the command line. The following arguments can be specified with the OPTIONS keyword. They are described

, "SQL Loader Command-Line Reference'.

SKIP = n

LOAD = n

ERRORS = n

ROWS = n

BINDSIZE = n

SILENT = {FEEDBACK | ERRORS | DISCARDS | ALL}

DIRECT = {TRUE | FALSE}

PARALLEL = {TRUE | FALSE}

For example:

OPTIONS (BINDSIZE=100000, SILENT=(ERRORS, FEEDBACK) )

Values specified on the command line override values specified in the OPTIONS statement of the control file. The OPTIONS keyword file establishes default values that are easily changed from the command line.