Топ-100
 
CerebroSQL

ALTER ROLLBACK SEGMENT

RDBMS Type: Oracle

unnamed (2).png

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;