Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segments
Happens to us all! No worries.
HJR
-- =============================!!============================= The views expressed are my own only, and definitely NOT those of Oracle Corporation =============================!!============================= "Andrew Mobbs" <andrewm_at_chiark.greenend.org.uk> wrote in message news:vxA*+h9Xo_at_news.chiark.greenend.org.uk...Received on Thu Jun 07 2001 - 06:27:57 CDT
> Howard J. Rogers <howardjr_at_www.com> wrote:
> >
> >Sorry, Andrew. But that is not what is happening. If the rollback
segment
> >cannot extend, that will produce a 'cannot extend' error, not a 1555.
> >Snapshot too old means that you have wrapped around the rollback segment,
> >and overwritten a block of rollback data which, although no longer
required
> >for transaction rollback, is still required for read consistency
purposes.
>
> Ack. Yes, sorry, I was completely wrong. I'll take my brain out and give
> it a good kicking.
>
> --
> Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/