Page 1 of 1
Oracle bulk load stage
Posted: Tue Feb 10, 2009 3:19 am
by sagar deshmukh
What is oracle bulk load stage?
how it is different from ordinary oracle stage?
Posted: Tue Feb 10, 2009 5:07 am
by ray.wurlod
Oracle bulk load stage is for server jobs, and creates data and control files for sqlldr. What do you mean by "ordinary"?
Posted: Tue Feb 10, 2009 7:48 am
by sagar deshmukh
So...Do we need to prepare control files also...?
or DS will prepare and we just need to mention the path...?
Posted: Tue Feb 10, 2009 8:17 am
by vinothkumar
DS will prepare datafile and control file. You have to specify the path alone
Posted: Tue Feb 10, 2009 8:46 am
by chulett
If we're still talking the Server stage, its behaviour depends on the 'mode' setting - Manual or Automatic. Manual means create the .ctl and .dat files and nothing more. Automatic performs the actual load without instantiating those files.
Posted: Tue Feb 10, 2009 2:14 pm
by ray.wurlod
However, the job type and forum are "parallel". Would you (sagar) care to re-phrase your question?