Q:Sql*Loader

From: <pjuanola_at_ctv.es>
Date: 1997/03/17
Message-ID: <332d8305.0_at_news.ctv.es>#1/1


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. Received on Mon Mar 17 1997 - 00:00:00 CET

Original text of this message