Name
DROP ROLLBACK SEGMENT
Synopsis
DROP ROLLBACK SEGMENT segment_name
Removes a rollback segment (segment_name) from
the database.
Notes
You must have the DROP ROLLBACK SEGMENT privilege to issue this
command. The rollback segment must be taken offline using the ALTER
ROLLBACK SEGMENT command before it can be dropped. When it is
dropped, all space used by the rollback segment is returned to the
free space pool.
Example
The following example removes the rollback segment RBS02 from the
database:
DROP ROLLBACK SEGMENT RBS02