Q:Sql*Loader
From: <pjuanola_at_ctv.es>
Date: 1997/03/17
Message-ID: <332d8305.0_at_news.ctv.es>#1/1
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