Online Documentation for SQL Manager for Oracle

Creating/editing rollback segment


Use the Rollback Segment tab of Rollback Segment Editor to create/edit a rollback segment and specify its properties.

 

Name

Specify the name of the rollback segment to be created, or view the name of the rollback segment being edited.

 

Tablespace

Use the drop-down list to select the tablespace in which the rollback segment is created.

 

Rollback Segment Editor - Editing Rollback Segment definition

 

CheckBox Public

Enable the option to indicate that the rollback segment is public and is available to any instance.

 

CheckBox Online

Check the option to bring the rollback segment online, making it available for transactions by your instance.

 

Storage

The Storage group lets you specify storage characteristics for the rollback segment: Initial size, Next size, Optimal size, Minimal number, Maximum number.

For more information see Storage attributes.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.