Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 18 of 30
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".
You must have the DROP
ROLLBACK
SEGMENT
system privilege.
rollback_segment |
is the name the rollback segment to be dropped. Restrictions:
|
The following statement drops the rollback segment ACCOUNTING
:
DROP ROLLBACK SEGMENT accounting;
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|