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

"I don't want to achieve immortality through my work; I want to achieve immortality through not dying." - Woody Allen

Related Commands:

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

Related Views:

 DBA_ROLLBACK_SEGS
 V$ROLLNAME
 V$ROLLSTAT 



Back to the Top

Simon Sheppard
SS64.com