Default: The name of the data file, with an extension of .
Specifies the name or location, or both, of the bad file associated with the first data file specification.
Syntax and Description
The bad file stores records that cause errors during insert or that are improperly formatted. If you specify the
BAD parameter, you must supply either a directory or file name, or both. If there are rejected records, and you have not specified a name for the bad file, then the name defaults to the name of the data file with an extension or file type of .bad.
directory parameter specifies a directory to which the bad file is written. The specification can include the name of a device or network node. The value of
directory is determined as follows:
BAD parameter is not specified at all and a bad file is needed, then the default directory is the one in which the SQL*Loader control file resides.
BAD parameter is specified with a file name but no directory, then the directory defaults to the current directory.
BAD parameter is specified with a directory but no file name, then the specified directory is used and the default is used for the bad file name and extension.
filename parameter specifies a file name recognized as valid on your platform. You must specify only a name (and extension, if one other than .bad is desired). Any spaces or punctuation marks in the file name must be enclosed in single quotation marks.
A bad file specified on the command line becomes the bad file associated with the first
INFILE statement (if there is one) in the control file. The name of the bad file can also be specified in the SQL*Loader control file, using the
BADFILE clause. If the bad file is specified in the control file, as well as on the command line, then the command-line value is used. If a bad file with that name already exists, then it is either overwritten or a new version is created, depending on your operating system
"Specifying the Bad File" for information about the format of bad files
The following specification creates a bad file named
emp1.bad in the current directory: