Listen Software Solutions' "How To" Series:
Rollback Segments
By David Nishimoto
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
Back to the LSS "How To" Series Main Page
|
