How to fix the Oracle error SQL*Loader-00471: OID or SID clause has an argument that is CONSTANT?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00471: OID or SID clause has an argument that is CONSTANT with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00471: OID or SID clause has an argument that is CONSTANT

Reason for the Error SQL*Loader-00471: OID or SID clause has an argument that is CONSTANT

You specified a CONSTANT as an argument in an OID clause for an object table or in the SID clause for a nested table column. Since these columns must have unique values, SQL Loader does not allow the a constant to be specified for their values.

How to fix the Error SQL*Loader-00471: OID or SID clause has an argument that is CONSTANT ?

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

Store the OID for each row in a filler field and specify the name of the filler field as an argument.