Re: Rollback Segment

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 Thu Sep 07 2000 - 12:25:27 CDT