How to fix the Oracle error SQL*Loader-00267: Control file must be first data file.?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00267: Control file must be first data file. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00267: Control file must be first data file.

Reason for the Error SQL*Loader-00267: Control file must be first data file.

The SQL*Loader control file is specified as containing data using the INFILE “*” clause, but other datafiles were named first.

How to fix the Error SQL*Loader-00267: Control file must be first data file. ?

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

Move the INFILE “*” clause so that it is the first datafile declared in the SQL*Loader control file.