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

Oracle Error Message

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

Reason for the Error

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.

Solution

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