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

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