Re: sqlloader - huge file load 70G

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..."