Oracle Error SQL*Loader-00254: Cannot have DISCARDFILE specs here when multiple data files

Oracle Error Message

SQL*Loader-00254: Cannot have DISCARDFILE specs here when multiple data files

Reason for the Error

The SQL*Loader control file contained multiple INFILE statements and a DISCARDFILE statement was found below the RESUME clause.

Solution

Move the DISCARDFILE statement above the RESUME clause, so it is adjacent to one of the INFILE statements.