Re: SQLLOAD / Rollback

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) Received on Thu Jul 27 1995 - 00:00:00 CEST