BL_DISCARDFILE=

BL_DISCARDFILE=

Determines the name and location of a file containing discarded rows.

Default value: creates a file in the current directory.

Syntax

BL_DISCARDFILE= path-and-discard-filename

path-and-discard-filename: An SQL*Loader discard file containing rows that were neither rejected nor inserted into the table; rather, these rows did not meet the specified criteria. You can specify the full path and filename in this argument, or use the default file name and location. The default action is to create a bl_<tablename>.dsc file in the current directory.

SQL*Loader creates the file of discarded rows.

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