LARGEROLLBACK Segments

<< Fixing Watermark Error in Replication | Journals | PL/SQL Exceptions Summary >>

Using a LARGE ROLLBACK SEGMENT Temporarily

alter rollback segment LARGE_RBS online;
begin
    set transaction use rollback segment LARGE_RBS;
    ... delete/insert, drop unused columns, etc...
    commit;
end;
/
alter rollback segment LARGE_RBS offline;