Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segments

Re: Rollback segments

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 7 Jun 2001 21:27:57 +1000
Message-ID: <3b1f6561$1@news.iprimus.com.au>

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...

> 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/
Received on Thu Jun 07 2001 - 06:27:57 CDT

Original text of this message

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