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

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

Cause: 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.

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

No comments:

Post a Comment