Re: Commit in batch

From: johnny_chan <johnny.chan_at_workmail.com>
Date: 2000/05/26
Message-ID: <392EE9A8.EC9927D2@workmail.com>#1/1

i presume you are blowing out the rollback segments, which is why you want to commit in subsets of inserts...

you can either write a pl/sql block to do commits between each subset of inserts or to avoid the issue altogather, do direct load insert after altering TABLE1 to be NOLOGGING. There are obvious recovery considerations to think about with the use of the second option...

Chua Boon Yiang wrote:

> Hi
>
> i am using an
>
> INSERT INTO TABLE1
> select * from TABLE2.
>
> But i keep hitting temp_ts is not enough message. May i know is there anyway
> to commit say every 1000 records inserted into TABLE1 ?
>
> Thanks
> Boon Yiang
Received on Fri May 26 2000 - 00:00:00 CDT