Hi Onkar, When you assigned a particular rollback segment to the transaction which is actually deleted, Oracle will use the default rollback segment. To assign a rollback segment to a particular transation use either:- DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT(NAME) OR DBMS_STANDARD.SET_ROLL_SEGS(NAME) Regards, Sunil Bhola Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> wrote: hi all, What will happen if i have assigned a particular rollback segment to a transactio but actually the RBS has been deleted???? -- Thanks & Regards, T. Onkar Nath Ph : +91-9826728111(Cell) to_onkar@xxxxxxxxx onkarnath.tiwary@xxxxxxxxx QUERIES in Oracle, Feel free to Join: http://groups.yahoo.com/group/oracle_expert/ Regards, Sunil Bhola Oracle_Expert, Moderator __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com