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

ORA-16119: building transaction at SCN string

1 Answers  


ORA-16726: the external condition supplied to resource manager is invalid

1 Answers  


TNS-02517: key smaller than requested size

1 Answers  


ORA-29655: USING clause is incompatible with its supertype

1 Answers  


SQL*Loader-00271: Not a Parallel load. Table level OPTIONS statement ignored.

1 Answers  






ORA-00821: Specified value of sga_target is too small, needs to be at least stringM

1 Answers  


DRG-12515: cannot specify language for stopwords in a BASIC_STOPLIST

1 Answers  


ORA-00068: invalid value string for parameter string, must be between string and string

1 Answers  


ORA-29258: buffer too small

1 Answers  


ORA-22991: insufficient space allocated for argument string

1 Answers  


ORA-02065: illegal option for ALTER SYSTEM

1 Answers  


ORA-26705: cannot downgrade capture process after Streams data dictionary has been upgraded

1 Answers  


Categories