BL_BADFILE=

BL_BADFILE=

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

Default value: creates a data file in the current directory

Syntax

Syntax

BL_BADFILE=path-and-filename

path-and-filename: An SQL*Loader file to which rejected rows of data are written. 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>.bad file in the current directory.

Details

The ORACLE SQL*Loader creates this file of rejected rows. Rows are rejected because they have caused errors during an insert, or because they are incorrectly formatted.

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

Chapter Contents
Previous
Next
Top of Page