Note:If your database is running in automatic undo mode, then this is the only valid operation on rollback segments. In that mode, you cannot create or alter a rollback segment.
You must have the
SEGMENT system privilege, and the rollback segment must be offline.
Specify the name the rollback segment to be dropped.
You can drop a rollback segment only if it is offline. To determine whether a rollback segment is offline, query the data dictionary view
DBA_ROLLBACK_SEGS. Offline rollback segments have the value
AVAILABLE in the
STATUS column. You can take a rollback segment offline with the
OFFLINE clause of the
You cannot drop the
SYSTEM rollback segment.
Dropping a Rollback Segment: Example The following syntax drops the rollback segment created in "Creating a Rollback Segment: Example":
DROP ROLLBACK SEGMENT rbs_one;