Re: Q: how do I commit in an import (i forgot)

Commit = y on the command line will commit after each buffer array is full, thus COMMIT=Y with BUFFER=4096000 will commit every 4 MB of data. Large tables will fill up in 4 MB chunks and any failures will only rollback the last 4MB of insert leaving all previous rows in the table.

AMARENDRA B NETTEM wrote in message <34C8E4FB.8F4_at_charlie.cns.iit.edu>...
>Gary Assa wrote:
>>
>> I forgot what command line parameters to use when I want to commit, say,
 every
>> 10000 rows, or 5 megabytes.
>>
>> I know COMMIT=Y must be used, but I forgot what other parameter.
>>
>> Was it something to do with BUFFER, or RECORDLENGTH, or ARRAYSIZE, or
 something
>> like these?
>> --
>> ------------------------------------
>> If you have a condom and sunscreen SPF 15 or greater, than it's safe to
 look at
>> http://www.panix.com/~gsa/index.html
>
>
>SET PARAMETER COMMIT =Y (DEFAULT N , By default, Import commits after
>loading each object and Import will perform a rollback when an error
>occurs before continuing with the next object) commit after each array
>insert( buffer size).
>
>Hope this helps
>
>AMARENDRA
>
>--
>***************************************************************************
 ***
>AMARENDRA B NETTEM 5039 N E River Road, Apt. 1A
>Oracle Certified DBA (OCP) NORRIDGE, IL 60656
>Whittman-Hart Inc.,
>311 South Wacker Drive, Suite 3500
>Chicago, IL 60606.
>
>Ph.No. (708) 583 9870 (H)
> (312) 913 6758 (W)
>
> E-mail:nettama_at_charlie.cns.iit.edu,
> anettem_at_whittman-hart.com
>
>Homepage: http://www.iit.edu/~nettama
>
>***************************************************************************
 *
>Opinions are mine and do not necessarily reflect those of Whittman-hart
>Inc.
Received on Sun Jan 25 1998 - 00:00:00 CST