What is the best way to load Huge Volume of History data?

srini_ramesh · Post by **srini_ramesh** » Fri Jan 28, 2005 12:18 am

Hi,
What is the best method to load voluminous data into oracle tables using a parallel job in DS. What stages can i use that would be most helpful in fast loading?

ray.wurlod · Post by **ray.wurlod** » Fri Jan 28, 2005 12:44 am

I'd opt for a solution that prepared data files for SQL*Loader, then use that actually to load the Oracle tables.

What volume of data do you consider "huge"?

I note that you are claiming to be running parallel jobs on Windows. Is this really the case?

Finally, please don't post the same question more than once. We aren't paid to be urgent; but we do get around to answering when we can. If you want urgent answers, sign up for 7x24 support, and discover the true (monetary) value of "urgent".

kcbland · Post by **kcbland** » Fri Jan 28, 2005 9:14 am

Release 7.5x2 is PX on NT.

ray.wurlod · Post by **ray.wurlod** » Fri Jan 28, 2005 4:34 pm

I just wanted to check that the OP was across this!