Help_load data from a dataset file to a oracle table

[Faye]

Hi Everybody,

I have to load data from a dataset file to a oracle table.
In oracle stage I need to delete some data from oracle table first and then load the dataset into oracle table.
I use Close Command option with the DELETE SQL:Delete from TableNaMe where condition...

I first time I run the job successful,but when I run the job twice,the job abort.

below is the error message:
The system(sqlldr CONTROL=ora.29628.383218.3.ctl LOG=ora.29628.383218.3.log BAD=ora.29628.383218.3.log.bad SILENT=header PARFILE=ora.29628.383218.3.par) failed; see the log file for the Oracle specific message.

Please advice to improve performance.

Thanks in advance

[Faye]

waiting for your reply on line,Many thanks!!!

[ray.wurlod]

Six minutes?!!!! That's gotta be a DSXchange record for impatience!!

Hey, I know you're new, but please realise that DSXchange is an all volunteer site, whose members post as and when they can.

If you want immediate response sign up with your official support provider for priority service, and learn just how much "urgent" costs.

[chulett]

see the log file for the Oracle specific message.

... and the message is?

[Faye]

Six minutes?!!!! That's gotta be a DSXchange record for impatience!!

Hey, I know you're new, but please realise that DSXchange is an all volunteer site, whose members post as and when they can.

If you want immediate response sign up with your official support provider for priority service, and learn just how much "urgent" costs.

Thansk! this problem has been resoled.