How to fix the Oracle error SQL*Loader-00468: OID directive expects 1 argument, number found.?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00468: OID directive expects 1 argument, number found. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00468: OID directive expects 1 argument, number found.

Reason for the Error SQL*Loader-00468: OID directive expects 1 argument, number found.

More than one argument was specified for an OID clause.

How to fix the Error SQL*Loader-00468: OID directive expects 1 argument, number found. ?

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

Specify the name of the field containing the value to use for the OID. If the OID for the table is user-defined, then do not use the OID clause in the control file.