Re: SQLLOAD / Rollback

In <3v8kq4$a3g_at_ixnews3.ix.netcom.com> pranav_at_ix.netcom.com (Gopalakrishnan Hariharan ) writes:
>
>In <3v5a51$1tb_at_dub-news-svc-6.compuserve.com> babini_at_bwi.bepr.ethz.ch
>(Dr. Mario A. Babini) writes:
>>
>>When I try to load a big table with sqlload, I get an error because
 the rollback segments
>>cannot be extended. This is because there is no commit during the
 load.
>>
>>Is there a way to execute a commit during the load?
>>
>>Thanks for any tips
>>
>>Mario
>
>there are two parameters (named)
>
> commit
> buffer
>
>these two can be used to control how frequently sqlload issues a
>commit. However, I believe the default is every 64 records (unless
>I am totally off). I will also help identify the design of
>the rollback segments (extents, and the optimal parameter of rollback
>segments if there are many)
>
I am sorry for the mixup these are import parameters

for sqlload the equivalent is ROWS Received on Thu Jul 27 1995 - 00:00:00 CEST