Re: [PERFORM] bulk data loading

2008-04-08 Thread Magnus Hagander
Potluri Srikanth wrote: > Hi all, > > I need to do a bulk data loading around 704GB (log file size) at > present in 8 hrs (1 am - 9am). The data file size may increase 3 to > 5 times in future. > > Using COPY it takes 96 hrs to finish the task. > What is the best way to do it ? > > HARDWARE: S

[PERFORM] bulk data loading

2008-04-07 Thread Potluri Srikanth
Hi all, I need to do a bulk data loading around 704GB (log file size) at present  in 8 hrs (1 am - 9am). The data file size may increase 3 to 5 times in future. Using COPY it takes 96 hrs to finish the task. What is the best way to do it ? HARDWARE: SUN THUMPER/ RAID10 OS : SOLARIS 10. DB: Gree