When editing or creating a new rollback segment, use the OK button to save your changes and the Cancel button to cancel your changes.

Note:

The user you used to register the server needs to have access to views DBA_ROLLBACK_SEGS, DBA_SEGMENTS and V$ROLLSTAT for this feature to work.

Creating a New Rollback Segment

Use the New Rollback Segment to start the dialog as shown below:

The Rollback Segment dialog

Here you can specify the Rollback Segment attributes.

By using the "[default]" for the extent attributes, you're using the database defaults.

Editing a Rollback Segment

Double clicking a rollback segment will show the Edit Rollback Segment dialog, similar to the one above.

Some options might be read only, like the name and tablespace.

Using the Online checkbox you can take the rolback segment offline or bring it online, see below.

Dropping a Rollback Segment

You can only drop a rollback segment with a status of OFFLINE. When using the Drop Rollback Segment button, you will be asked to confirm and if you choose Yes, the rollback segment will be dropped.

Take a Rollback Segment Offline

If you take a rollback segment offline, it will no longer be used by Oracle to hold data needed to rollback DML statements. Once taken offline, you can drop the rollback segment.

You can take a rollback segment offline by selecting an active rollback segment and using the Take Offline button.

Take Offline button

After the confirmation, Database Workbench will attempt to take the rollback segment offline. In case of errors, you will get a message and the rollback segment will stay online. If the status changes, the image for the rollback segment will change to a "grayed" image.

Bring a Rollback Segment Online

You can bring a rollback segment back online so that it's available for use by using the Bring Online button.

Bring Online button

After bringing a rollback segment online, the image of the rollback segment will change to an active one.