top of page
CerebroSQL

ALTER ROLLBACK SEGMENT

RDBMS Type: Oracle

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