Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql loader -- How to COMMIT only at the end of the load file?
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