Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql loader -- How to COMMIT only at the end of the load file?

Re: sql loader -- How to COMMIT only at the end of the load file?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 06 Dec 2005 15:47:41 -0800
Message-ID: <1133912841.508694@jetspin.drizzle.com>


SP wrote:
> I am on Oracle 9i and using conventional path load because of trigger
> in the table. Is there a way to make it commit at the end of the load
> file? The files I am trying to load are around 100M. I tried to use
> ROWS and bindsize but sql loader crashed with "SQL*Loader-700: Out of
> memory while performing essential allocations [7]". I already looked
> at Oracle doucmentation but didn't see anything on this. Any help on
> this would be greatly appreciated.
> Thanks,
> SP

No.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Dec 06 2005 - 17:47:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US