Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-01552: cannot use system rollback segment for non-system tablespace 'string'
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-lReceived on Tue Nov 13 2007 - 23:59:59 CST
![]() |
![]() |