Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 26 of 26
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:
|
You must have the DROP
ROLLBACK
SEGMENT
system privilege.
drop_rollback_segment::=
Specify the name the rollback segment to be dropped.
Restrictions on dropping rollback segments:
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.SYSTEM
rollback segment.The following statement drops the rollback segment rbs_ts
:
DROP ROLLBACK SEGMENT rbs_ts;
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|