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

Re: SQL Loader

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 17 Oct 2001 12:53:49 +0200
Message-ID: <tsqpqdd1mf9r4e@corp.supernews.com>

"Allan Martin" <allan.martin_at_saic.com> wrote in message news:3bccf814_at_cpns1.saic.com...
> Hi,
> Is it possible to change the commit point in SQL Loader. At the moment
> it seems to be committing every record. I'd like to change this to commit
> every 100 records or something.
>
> Thanks in advance.
> Allan
>
>

1 No need to post this in the complete Oracle hierarchy 2 check out the buffer parameter in the Oracle Server Utilities Manual

Regards.

Sybrand Bakker
Senior Oracle DBA Received on Wed Oct 17 2001 - 05:53:49 CDT

Original text of this message

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