dcsimg

Listen Software's How To: Rollback Segments

March 4, 2002

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








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers