Re: ORA-01552: cannot use system rollback segment for non-system tablespace 'string'

Thanks everyone for your suggestions. Yes, I do have an UNDO tablespace online. It was not full, it was not busy. The problem was in what the developer was doing. He managed to resolve it before I got back to him. Seems he modified his environment for the run on production from what he had in the other two environments. When he did everything the same way, it worked the same way. Imagine that!

Thanks again.

Sandy

On Nov 14, 2007 1:07 AM, Nilo Segura <nilosegura_at_gmail.com> wrote:
> You can get that error too if the status for your rollback segments is
> FULL, leaving only the system rollback segment available, that one can
> not be used for normal operations.
>
> Check v$rollstat...
>
>
> On 11/14/07, Peter van Rijn <petervanrijn_at_gmail.com> wrote:
> > SQL> set transaction use rollback segment r;
> > set transaction use rollback segment r
> > *
> > ERROR at line 1:
> > ORA-01534: rollback segment 'R' doesn't exist
> >
> >
> >
> > Taylor, Chris David schreef:
> > > Just off the cuff here, but does the application code perform a "SET
> > > TRANSACTION USE ROLLBACK SEGMENT" statement? I can't remember the error
> > > that returns off hand.
> > >
> >
> >
>
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Nilo Segura
> Oracle Support - IT/DES
> CERN - Geneva
> Switzerland
>

--
http://www.freelists.org/webpage/oracle-l