Thursday, August 25, 2005

LARGE ROLLBACK Segments

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;

0 Comments:

Post a Comment

<< Home