Oracle stage truncate and load

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sureshabbisetti
Participant
Posts: 21
Joined: Thu Oct 04, 2007 4:34 am
Location: India
Contact:

Oracle stage truncate and load

Post by sureshabbisetti »

Hi,

I am trying to load a table with truncate option. But the job got aborted and table got loaded with out truncating the data. Should I change any environment settings?

I am getting the following error:

Oracle_Enterprise_1,0: The call to sqlldr failed; the return code = 256;
please see the loader logfile: /scratch/ora.930028.244413.0.log for details


Thanks & Regards
Suresh
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

What does the log file "/scratch/ora.930028.244413.0.log" contain?
Post Reply