Cry How To...

Add a new rollback segment

The easiest way to add a new roll back segment is to use Oracle storage manager. Alternately the SQL to add a roll back segment is as follows:

Create public rollback segment "<NAME>"
Tablespace "<Rollback-tablespace>"
Storage (Initial <XX>K Next <XX>K Optimal <XX>K Maxextents Unlimited);
Alter rollback segment "<NAME>" online;