Re: Yet another ORA-01555 question

From: VC <boston103_at_hotmail.com>
Date: Tue, 30 Mar 2004 23:00:41 GMT
Message-ID: <t_mac.143812$po.875002@attbi_s52>

Hello,

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:4069F2E4.B01EDDCA_at_remove_spam.peasland.com...
> Andrew Metcalfe wrote:
> >
> > Would the small size of this one segment be the cause of my error?
> >
> > Or do I need to add more segments?
> >
> > _Am
>
> Are you sure that your error indicated that the rollback segment did not
> have enough space? In this case, it may be more likely that your
> rollback segment was trying to extend, but the tablespace did not have
> enough space. Have you checked for that condition? You may also want to
> post the exact error number and message.

One would imagine that by now it's a well-known fact ORA-1555 indicates a query (SELECT) failure to build a read consistent image, not inability to extend the RBS. A READ transaction does NOT extend a rollback segment, only a WRITE one does.

>
> HTH,
> Brian
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Tue Mar 30 2004 - 17:00:41 CST