Re: SQLLOAD / Rollback
From: Phil Fielder <fimad_at_archie.lanl.gov>
Date: 1995/07/27
Message-ID: <3v87qh$l9e_at_newshost.lanl.gov>#1/1
Date: 1995/07/27
Message-ID: <3v87qh$l9e_at_newshost.lanl.gov>#1/1
babini_at_bwi.bepr.ethz.ch (Dr. Mario A. Babini) wrote:
>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?
Mario,
Use the imp parameter, Commit=Y, to reduce size of rollback segs. Also
for large imports, some oracle tuning guides recommend increasing the number
of rows in the array that is inserted using the Buffer parameter, (e.g.
Buffer=10240000). Pertinent documentation is : Oracle7 Server Utilty User's
Guide, Ch 2.
phil
-- Philip Fielder YellNet 505.665.3227 Facility for Infor.,Management, EES-5/MS D452 FaxNet 505.667.1628 Analysis and Display FIMAD/Los Alamos Nat. Lab Los Alamos, NM 87545 URL : http://ees5-www.lanl.gov/EES5/fimad/fimad_main.htmlReceived on Thu Jul 27 1995 - 00:00:00 CEST