big rollback and undo tablespace...

big rollback and undo tablespace...

 

  

hello experts,

with 8i when i need the big rollback segment, i do that :

set transaction use rollback segment rbs_big;

i can specify a long transaction for a big rollback segment.

with 9i, i use the undo_tablespace , what can i do when i need a big
rollback segment for a long transaction..?
does the undo_tablespace manage it itself..?

need your suggestions..
thanks a lots.

david.

Oracle LazyDBA home page