Listen Software’s How To: Rollback Segments

Creating a Rollback Segment

CREATE ROLLBACK SEGMENT {myRBS01}
TABLESPACE {myrollback_tablespace}
STORAGE
(
   INITIAL 100K
   NEXT 100K
   MINEXTENTS 20
   MAXEXTENTS 121
)

Bringing a Rollback Segment Online

alter rollback segment {myRBS01} online;

rollback segments need to be entered into the init{sid}.ora file

ROLLBACK_SEGMENTS=({myRBS01})

David Nishimoto
For Listen Software

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles