Oracle Error Message
SQL*Loader-00415: column string in table string cannot use and be the object of an SDF or LOBFILE
Reason for the Error
The named column is identified as the target of a secondary data file (SDF) or LOBFILE clause. However, the column also gets it’s value from an SDF or LOBFILE. If a field name is named in an SDF or LOBFILE clause, then that field cannot have an SDF or LOBFILE clause.
Solution
Verify that the SDF and LOBFILE clauses in the SQL*Loader control file name the correct fields. Also verify that the SDF and LOBFILE clauses are specified for the correct field.
