How to fix the Oracle error SQL*Loader-00284: Warning: Input data file string specified multiple times.?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00284: Warning: Input data file string specified multiple times. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00284: Warning: Input data file string specified multiple times.

Reason for the Error SQL*Loader-00284: Warning: Input data file string specified multiple times.

The same input datafile is loaded multiple times. This can occur if the INFILE keyword is placed out of order in the load syntax statement, which causes the filename of the first datafile loaded to default to the name of the control file with an extension or file type of DAT.

How to fix the Error SQL*Loader-00284: Warning: Input data file string specified multiple times. ?

You can fix this error in Oracle by following the below steps

Check that INFILE keyword is not placed after one of these – BADFILE/BADDN/DISCARDFILE/DISCARDDN/DISCARDS.