Re: DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT question

Anonymous wrote:
>
> Hi all,
>
> I am using DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT to assign a
> particular rollback segment for a transaction. However, I found that
> even I specify a non-exist rollback segment to this function, there is
> no error message return. How can I check whether the rollback segment
> passed to this function is a valid rollback segment?
>
> Thanks,
> David

Are you sure ?

SQL> exec dbms_transaction.uSE_ROLLBACK_SEGMENT('qwe'); BEGIN dbms_transaction.uSE_ROLLBACK_SEGMENT('qwe'); END;

*
ERROR at line 1:

ORA-01534: rollback segment 'QWE' doesn't exist
ORA-06512: at "SYS.DBMS_TRANSACTION", line 65
ORA-06512: at line 1

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."