Re: slow sqlldr

have a look at the parallel option if in direct path mode, or just run several conventional loads simultaneously (same effect -- parallel).

look into the sql*loader documentation, there are numerous options and ways to speed things up (splitting files, buffer size etc).

Cheers,

Bricklen

Celia wrote:
>
> I'm using conventional loading. I try tu use direct path while other
> load was running but i have an error because the table was busy.
> Thanks again
>
> Bricklen Anderson <bricklen_at_shaw.ca> wrote in message news:<3CCD88FC.7AEBD2D9_at_shaw.ca>...
> > are you using direct path loading or conventional? Direct path is way
> > faster...
> >
> > Celia wrote:
> > >
> > > Hi
> > >
> > > I need to insert a lot of data into a db but the sqlldr is so slow
> > > and i asked me if there is a command or something else that allow me
> > > to do the sqlldr more quickly
> > >
> > > ¿someone can help me??
> > >
> > > Thanks
 

-- 
 
 
 -----------------------------
* http://pipers.hypermart.net *
 -----------------------------