Database Error Messages

SQL*Loader-00570

Warning: single bad file specification with multiple data files using string file may get overwritten.

Cause

The value specified for the BADFILE parameter contained something other than a directory specification (for example, it contained a file name). The INFILE specification had wildcards or the data command line parameter specification contained a comma-separated list or wildcards and the result was more than one data file. In that case, the BADFILE specification or the BAD command line parameter value should be a directory specification only and should not contain a file name.


Action

No action is needed. This is a warning. However, for a parallel load with external tables or express mode, the file may get overwritten or may get corrupted due to contention on the file by multiple parallel query slaves. Try the operation again with a directory only or omit the parameter and use the default bad file name.