DROP ROLLBACK SEGMENT

Purpose

Use the DROP ROLLBACK SEGMENT to remove a rollback segment from the database. When you drop a rollback segment, all space allocated to the rollback segment returns to the tablespace.

Note: If your database is running in Automatic Undo Management mode, this is the only valid operation on rollback segments. In that mode, you cannot create or alter a rollback segment.

See Also: CREATE ROLLBACK SEGMENT for information on creating a rollback segment ALTER ROLLBACK SEGMENT for information on modifying a rollback segment CREATE TABLESPACE

Prerequisites

You must have the DROP ROLLBACK SEGMENT system privilege.

Syntax

drop_rollback_segment::=

Text description of drop_rollback_segment

Keywords and Parameters

rollback_segment

Specify the name the rollback segment to be dropped.

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 AVAILABLE in the STATUS column. You can take a rollback segment offline with the OFFLINE clause of the ALTER ROLLBACK SEGMENT statement.

• You cannot drop the SYSTEM rollback segment.

Example

DROP ROLLBACK SEGMENT Example

The following statement drops the rollback segment rbs_1:

DROP ROLLBACK SEGMENT rbs_1;