Re: sqlloader - huge file load 70G

Absolutely correct. I managed a database where I loaded 10X that once a month. And Connor is correct. But start thinking about your back-up and recovery now. That won't be so pretty either.

Daniel Morgan

Connor McDonald wrote:

> shankar wrote:
> >
> > Hello all,.
> > I am required to load 70G data file using sqlloader into a oracle table.
> > The 70G file will be split into 1G file each.
> >
> > Has any of you done any mass loading like this using sqlloader?
> >
> > if so, please tell me about the possible problems.
> >
> > thanks
> > shankar
>
> Use direct load, defer indexing until post-load, use parallel load and
> you'll be amazed at the results...You can get 10's of millions of rows
> in minutes.
>
> PS - you probably also wanna be looking at partitioning
>
> hth
> connor
> --
> ==============================
> Connor McDonald
>
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue..."
Received on Tue Jan 22 2002 - 13:32:16 CET