Re: ORA 01555

From: Dirk Mika <dirk.mika.dm1_at_bayer-ag.de>
Date: Wed, 19 Jan 2000 11:53:29 +0100
Message-ID: <388597A9.F9421CDE@bayer-ag.de>

Hi,

create a larger rollback segment,
use set transaction using rollback segment to force your transaction use the large segment,
delete or set offline the large rollback segment.

Regards

Dirk Mika

Venu Nair schrieb:
>
> Hi,
> I have a long running delete transaction which generates the following
> error:
>
> ORA 01555: Snapshot too old.Rollback segment number with name RB5 too
> small.
>
> What is the necessary action to deal with this?
>
> Thanks,
> Venu Nair
> venu_at_talentdev.ch

--
Dirk Mika
Bayer AG Received on Wed Jan 19 2000 - 04:53:29 CST