Oracle8i SQL Reference
Release 2 (8.1.6)

A76989-01

Library

Product

Contents

Index

Prev Up Next

SQL Statements (continued), 18 of 30


DROP ROLLBACK SEGMENT

Syntax


Purpose

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.

For information on creating a rollback segment, see CREATE ROLLBACK SEGMENT. See also "CREATE TABLESPACE".

Prerequisites

You must have the DROP ROLLBACK SEGMENT system privilege.

Keywords and Parameters

rollback_segment 

is 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

The following statement drops the rollback segment ACCOUNTING:

DROP ROLLBACK SEGMENT accounting; 

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index