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;

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.