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})