Migrating to UNDOTS from Rollback Segment

[dsekhar_2000]

Hi all,

We have Oracle 10g database. At present we are using Rollback segments (6 RBS) instead of UNDOTBS. Now we are planning to switch over to UNDOTBS.

I don't know how to switch over from RBS to UNDOTBS.

please help in this matter

Advanced Thanks

Edit by admin: no contact info permitted on the forum, thank you

[gandolf989]

You should start by creating an undo tablespace. Assuming you call it undotbs1 you can just add the following to your init file/spfile.

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_retention=3600
undo_tablespace=UNDOTBS1

You may want to check your code for SET TRANSACTION statements that try to aquire a specific rollback segment. You will need to get rid of these as they will now cause errors. You will also want to drop all but the system rollback segment. Finally test everything before you change anything in prod.