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

Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlldr and commit

Re: sqlldr and commit

From: MarkyG <markg_at_mymail.tm>
Date: 21 Feb 2002 02:20:22 -0800
Message-ID: <ab87195e.0202210220.56b4c841@posting.google.com>


You can use the ROWS option in your control file to specify how many rows to buffer during insert and commit. Try setting to 1.

Bear in mind that your loading speed and DB performance will be effected with all the commits happening.

M

C Chang <cschang_at_maxinter.net> wrote in message news:<3C748028.3F5C_at_maxinter.net>...
> If I have a multi-records file to load into a DB table by using
> sqlldr80, how do I make the insert all commited immediately? I just had
> a case that during the inserting, another procedure is running a select
> .. on the same table, but miss the records been just inserted. The
> steps is supposed to be inserting first completely than select or select
> first than insert new records. How do I avoid the conflict?
>
> C Chang
Received on Thu Feb 21 2002 - 04:20:22 CST

Original text of this message

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