|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
CREATE CLUSTER to CREATE SEQUENCE, 23 of 25
SEGMENT statement to create a rollback segment, which is an object that Oracle uses to store data necessary to reverse, or undo, changes made by transactions.
You must have
SEGMENT system privilege.
PUBLIC to indicate 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
Specify the name of the rollback segment to be created.
TABLESPACE clause to identify the tablespace in which the rollback segment is created. If you omit this clause, Oracle creates the rollback segment in the
Restriction: You cannot create a rollback segment in a tablespace that is system managed (that is, during creation you specified
storage_clause lets you specify the characteristics for the rollback segment.
The following statement creates a rollback segment with default storage values in the system tablespace:
The above statement is equivalent to the following: