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: rollback segment not big enough

Re: rollback segment not big enough

From: Dave Klinger <dklinger_at_bechtel.com>
Date: Fri, 9 Oct 1998 15:57:42 GMT
Message-ID: <361E3276.A4D3E841@bechtel.com>


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

Original text of this message

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