Cause: The named column is identified as the target of a secondary data fi

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

Question Posted / guest

1 Answers
3539 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

RMAN-05017: no copy of datafile number found to recover

2412

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2245

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3389

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2807

NZE-28868: Peer certificate chain check failed.

2806

ORA-26084: direct path context already finished

1954

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2707

ORA-26076: cannot set or reset value after direct path structure is allocated

1973

IMP-00064: Definition of LOB was truncated by export

6418

ORA-26032: index string.string loading aborted after string keys

2112

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2736

IMG-02003: 2FF03 - incorrect color histogram feature specification

1713

ORA-26028: index string.string initially in unusable state

3867

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2733

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1626