ALTER ROLLBACK SEGMENT

Take an existing RBS on-line or off-line or change its storage parameters.

Syntax:

   ALTER ROLLBACK SEGMENT rbs_name {ONLINE | OFFLINE}
   ALTER ROLLBACK SEGMENT rbs_name STORAGE storage_clause
   ALTER ROLLBACK SEGMENT rbs_name SHRINK [TO int {K | M}]

"Never mistake motion for action" - Ernest Hemmingway

Related Commands:

CREATE ROLLBACK SEGMENT
DROP ROLLBACK SEGMENT

Related Views:

 DBA_ROLLBACK_SEGS
 V$ROLLNAME
 V$ROLLSTAT 



Back to the Top

Simon Sheppard
SS64.com