Page 1 of 1

Oracle stage truncate and load

Posted: Wed Jun 04, 2008 3:35 am
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

Posted: Wed Jun 04, 2008 3:39 am
by ArndW
What does the log file "/scratch/ora.930028.244413.0.log" contain?