Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


SQL*Loader-00415: column string in table string cannot use
and be the object of an SDF or LOBFILE



SQL*Loader-00415: column string in table string cannot use and be the object of an SDF or LOBFILE..

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

O2U-00201: Illegal arguments to function o2upt()

1 Answers  


NZE-29118: Cannot create PKCS #12 attributes.

1 Answers  


ORA-27509: IPC error receiving a message

1 Answers  


ORA-34346: (MXDSS04) The string analytic workspace cannot be detached.

1 Answers  


LRM-00108: invalid positional parameter value 'string'

1 Answers  






ORA-34061: (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.

1 Answers  


RMAN-08509: destination for restore of datafile string: string

1 Answers  


KUP-00600: internal error, arguments [string] [string] [string] [string] [string]

1 Answers  


ORA-37129: (XSCCOMP04) The AGGMAP workspace object cannot be used to aggregate the VARIABLE workspace object. All static MODEL statements must precede all RELATION statments over the bases of the COMPRESSED COMPOSITE.

1 Answers  


ORA-02144: no option specified for ALTER CLUSTER

1 Answers  


ORA-29302: database is not open clone

1 Answers  


QSM-02179: MV with UNION ALL requires compatibility >= 9.2

1 Answers  






Categories