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.
Restrictions on Dropping Rollback Segments
This statement is subject to the following restrictions:
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
STATUScolumn. You can take a rollback segment offline with the
OFFLINEclause of the
You cannot drop the
Dropping a Rollback Segment: Example
The following syntax drops the rollback segment created in "Creating a Rollback Segment: Example":
DROP ROLLBACK SEGMENT rbs_one;