ORACLE: ALTER ROLLBACK SEGMENT [EN]
top of page
CerebroSQL

Oracle:

ALTER ROLLBACK SEGMENT

ALTER ROLLBACK SEGMENT rollback_segment
{ ONLINE
| OFFLINE
| storage_clause
| SHRINK [ TO size_clause ]
};

example

ALTER ROLLBACK SEGMENT rbs_one ONLINE;

ALTER ROLLBACK SEGMENT rbs_one
SHRINK TO 100M;

bottom of page