Q:Sql*Load

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.  

                        Pere Juanola i Juanola
                       E-Mail : pjuanola_at_ctv.es
		   http://www.ctv.es/USERS/pjuanola


===================================================================