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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-01552: cannot use system rollback segment for non-system tablespace 'string'

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

From: Peter van Rijn <petervanrijn_at_gmail.com>
Date: Wed, 14 Nov 2007 06:59:59 +0100
Message-ID: <473A8EDF.8030405@gmail.com>


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
Received on Tue Nov 13 2007 - 23:59:59 CST

Original text of this message

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