Create a Rollback Segment (RBS)
CREATE [PUBLIC] ROLLBACK SEGMENT rbs_name option(s) Options: TABLESPACE tablespace_name STORAGE storage_clause
A public RBS is available for use by more than one instance
If you use rollback segments to manage undo space, you are operating in manual undo management mode.
If you use an undo tablespace, you are operating in automatic undo management mode. You determine the mode at instance startup using the UNDO_MANAGEMENT initialization parameter.
"I don't want to achieve immortality through my work; I want to achieve immortality through not dying" ~ Woody Allen
init.ora - ROLLBACK_SEGMENTS = rb1, rb2…
ALTER ROLLBACK SEGMENT
DROP ROLLBACK SEGMENT
DBA_ROLLBACK_SEGS V$ROLLNAME V$ROLLSTAT
© Copyright SS64.com 1999-2013
Some rights reserved