BL_OPTIONS=

BL_OPTIONS=

Passes SQLLDR options to SQL*Loader.

Default value: ERRORS=1000000

Syntax

Syntax

BL_OPTIONS='SQLLDR option<,. . . SQLLDR option>'

'SQLLDR option<, . . . SQLLDR option>': one or more SQL*Loader options that are appended to the SQL*Loader invocation command. Separate multiple options with commas and enclose the entire string of options in single quotation marks.

Details

BL_OPTIONS= enables you to pass SQL*Loader options to SQL*Loader when it is invoked, thereby affecting how data is loaded and processed. In the following example, BL_OPTIONS= specifies the number of errors permitted during a load of 2,000 rows of data. Notice that the entire listing of options is quoted and not each individual option:

bl_options='ERROR=999,LOAD=2000'

The default value for BL_OPTIONS= overrides the default value for the ORACLE SQL*Loader ERROR= option, which is 50. See the Oracle utilities documentation for SQL*Loader options that you can specify in BL_OPTIONS=.

To specify BL_OPTIONS=, you must first specify YES for the option BULKLOAD=.

Chapter Contents
Previous
Next
Top of Page