Re: Rollback Segment

From: Emre Akbag <akbag_at_scr.siemens.com>
Date: Fri, 08 Sep 2000 18:39:55 GMT
Message-ID: <%nau5.782$f44.29401@ord-read.news.verio.net>

There is also another way of commiting a certain number of records.

set copycommit 1
set arraysize 1000

This commits after each record block of 1000.

"Yong Huang" <yhuang_at_indigopool.com> wrote in message news:8p8j84$19u$1_at_news.sinet.slb.com...
> There's no way to disable rollback in Oracle. To disable generating redo
(in
> fact, usually not completely disable), you can use direct load insert with
> nologging on the table to be inserted into.
>
> You need to consider putting your insert in a loop in a PL/SQL block and
> count for, say, 100 inserts, do a commit.
>
> Yong Huang
> yhuang_at_indigopool.com
>
> Jeff Smelser <tradergt_at_bigfoot.com> wrote in message
> news:Pine.LNX.4.10.10009061758370.19174-100000_at_server.smelser.org...
> > I can't remember how to disable rollbacks for large inserts. I am
running
> > out of rollback segments and really don't want to create a rollback
> > segment for this.
> >
> > Thanks,
> > Jeff
> >
> >
> >
>
>
Received on Fri Sep 08 2000 - 13:39:55 CDT