Oracle bulk load stage

sagar deshmukh · Post by **sagar deshmukh** » Tue Feb 10, 2009 3:19 am

What is oracle bulk load stage?
how it is different from ordinary oracle stage?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 10, 2009 5:07 am

Oracle bulk load stage is for server jobs, and creates data and control files for sqlldr. What do you mean by "ordinary"?

sagar deshmukh · Post by **sagar deshmukh** » Tue Feb 10, 2009 7:48 am

So...Do we need to prepare control files also...?
or DS will prepare and we just need to mention the path...?

vinothkumar · Post by **vinothkumar** » Tue Feb 10, 2009 8:17 am

DS will prepare datafile and control file. You have to specify the path alone

chulett · Post by **chulett** » Tue Feb 10, 2009 8:46 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 10, 2009 2:14 pm

However, the job type and forum are "parallel". Would you (sagar) care to re-phrase your question?