Re: Yet another ORA-01555 question

VC wrote:
>
> 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.

You are correct. It should be obvious that I got stuck on the OP's comment that the rollback segment was too small, instead of the topic of the ORA-1555 error. Oops.

Sorry,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"