undo tablespace and set transaction use rollback segment

when we were using oracle8i , whe had some process which use set transaction use rollback segment. and now we use undo tablespace and we have still same porocesses . how can set a rollbback segment for process with undo tablepsace -- Please see the official ORACLE-L FAQ: http

RE: Set transaction use rollback??

Hi Vishak I think you should use this statement when you want to assign a transaction to a specific Rollback Segment (generally a BIG Rollback), because the transaction is HUGE (as you said in you mail). Remember that when you issue a commit or rollback you close the current transaction and you

Set transaction use rollback??

Hello Gurus I just would like to know when this statement SET TRANSACTON USE ROLLBACK SEGMENT 'XXX' should be used exactly. In the sense should I always write it after a BEGIN(for all my programs) or should I write it in processes which involves HUGE volume of records. Please clarify