Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 3 of 11
storage_clause: See "storage_clause".
To create a rollback segment. A rollback segment is an object that Oracle uses to store data necessary to reverse, or undo, changes made by transactions.
For information on altering a rollback segment, see "ALTER ROLLBACK SEGMENT". For information on removing a rollback segment, see "DROP ROLLBACK SEGMENT".
You must have CREATE
ROLLBACK
SEGMENT
system privilege.
|
specifies that the rollback segment is public and is available to any instance. If you omit this clause, the rollback segment is private and is available only to the instance naming it in its initialization parameter |
|
rollback_segment |
is the name of the rollback segment to be created. |
|
|
identifies the tablespace in which the rollback segment is created. If you omit this clause, Oracle creates the rollback segment in the SYSTEM tablespace.
Restriction: You cannot create a rollback segment in a tablespace that is system managed (that is, during creation you specified |
|
|
Notes:
|
|
|
See also: Oracle8i Administrator's Guide for more information on creating rollback segments and making them available. |
|
storage_clause |
specifies the characteristics for the rollback segment. See the "storage_clause". |
|
|
Notes: |
The following statement creates a rollback segment with default storage values in the system tablespace:
CREATE ROLLBACK SEGMENT rbs_2TABLESPACE system;
The above statement is equivalent to the following:
CREATE ROLLBACK SEGMENT rbs_2 TABLESPACE system STORAGE ( INITIAL 10K NEXT 10K MAXEXTENTS UNLMIITED);
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|