Database Error Messages

SQL*Loader-00571

Warning: single discard file specification with multiple data files, using string, but file may get overwritten.

Cause

The value specified for the DISCARDFILE 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 DISCARDFILE specification or the DISCARD 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 discard file name.