Load Vs Upsert in Oracle Enterprise Stage

[Suman]

Hi,
I am trying to load some records into an Oracle table using Oracle Enterprise stage as target. The job is running fine with Upsert option. when I am using Load the job is failing. Is there any reason for failure. There is no primary key or constraint in the table. The table is created from datastage.

Regards,
Suman

[chulett]

Is there any reason for failure.

Of course there is, but *you* would need to tell *us* the reason. Post the actual errors that you get when the 'Load' option is used.

[Suman]

Is there any reason for failure.

Of course there is, but *you* would need to tell *us* the reason. Post the actual errors that you get when the 'Load' option is used.

The error is coming like this:
SETPOINT_MASTER_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG=ora.1221018.874080.9.log BAD=ora.1221018.874080.9.log.bad SILENT=header PARFILE=ora.1221018.874080.9.par) failed; see the log file for the Oracle specific message.his;
With upsert this error is not coming.

[Suman]

Is there any reason for failure.

Of course there is, but *you* would need to tell *us* the reason. Post the actual errors that you get when the 'Load' option is used.

The error is coming like this:
SETPOINT_MASTER_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG=ora.1221018.874080.9.log BAD=ora.1221018.874080.9.log.bad SILENT=header PARFILE=ora.1221018.874080.9.par) failed; see the log file for the Oracle specific message.his;
With upsert this error is not coming.

[Suman]

Is there any reason for failure.

Of course there is, but *you* would need to tell *us* the reason. Post the actual errors that you get when the 'Load' option is used.

The error is coming like this:
Table_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG=ora.1221018.874080.9.log BAD=ora.1221018.874080.9.log.bad SILENT=header PARFILE=ora.1221018.874080.9.par) failed; see the log file for the Oracle specific message.his;
With upsert this error is not coming.

Suman

[Suman]

The error is coming like this:
Table_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG=ora.1221018.874080.9.log BAD=ora.1221018.874080.9.log.bad SILENT=header PARFILE=ora.1221018.874080.9.par) failed; see the log file for the Oracle specific message.his;
With upsert this error is not coming.

Suman

[sanjay]

Suman

open ora.1221018.874080.9.log file it will give oracle error message why load fail.

Thanks
sanajy

The error is coming like this:
Table_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG=ora.1221018.874080.9.log BAD=ora.1221018.874080.9.log.bad SILENT=header PARFILE=ora.1221018.874080.9.par) failed; see the log file for the Oracle specific message.his;
With upsert this error is not coming.

Suman