Listen Software's How To: Rollback Segments

Monday Mar 4th 2002 by David Nishimoto
Share:

Examples of how to create a rollback segment and how to bring a rollback segment online.

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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved