CREATE ROLLBACK SEGMENT

Create a Rollback Segment (RBS)

Syntax:

   CREATE [PUBLIC] ROLLBACK SEGMENT rbs_name option(s)

   Options:
      TABLESPACE tablespace_name
      STORAGE storage_clause

A public RBS is available for use by more than one instance

If you use rollback segments to manage undo space, you are operating in manual undo management mode.

If you use an undo tablespace, you are operating in automatic undo management mode. You determine the mode at instance startup using the UNDO_MANAGEMENT initialization parameter.

“I don’t want to achieve immortality through my work; I want to achieve immortality through not dying” ~ Woody Allen

Related Oracle Commands:

init.ora - ROLLBACK_SEGMENTS = rb1, rb2…
ALTER ROLLBACK SEGMENT
DROP ROLLBACK SEGMENT

Related Views:

 DBA_ROLLBACK_SEGS
 V$ROLLNAME
 V$ROLLSTAT