Migrating to UNDOTS from Rollback Segment

[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.