Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Q:Sql*Load
Pere Juanola wrote:
>
> Hello,
> I'm loading plain ascii files into my database, and as these
> files are
> quite large i'd like to optimize the loading.
>
> I tried to raise the BINDSIZE to 1000000 and the ROWS to 1500
> but qhen
> I start SQLLOAD the commit is done every 172 (aprox.) when all the
> 1500 rows fit into the bindsize.
>
> I'd like to make a commit every 1000 rows.
>
> I'm using ORACLE 7.2 in a DIGITAL UNIX.
>
> If somebody can tell me what I'm doing wrong or if I'm missing
> something.
>
> Thanks in advance.
You might want to see if your load qualifies for a direct load. The Oracle Tools and Utilities manual specifies the condiions for a direct load. If you qualify, the load will go MUCH MUCH faster than a standard load.