Re: rollback segment not big enough

You have two choices. Either you have to explicitely give it a range of records to delete at one time or create a seperate tablespace and create one large rollback in it. Then you can specify using the SET TRANSACTION... USE ROLLBACK SEGMENT to explicitly use that large rollback for your delete transaction. If this is a one time deal, you can then delete the rollback and tablespace.

Dave

Zoran Kukoljac wrote:

> Hi,
> I am truing to delete a large number of row from one database table but
> the statement fails with message:
> "failed to extend rollback segment"
> Is it possible to "turn off" rollback feature only for one statement or
> session or to tell oracle to automatically commit after for example
> every 100 deleted rows ?
>
> Thanks, Zoran
Received on Fri Oct 09 1998 - 10:57:42 CDT