Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Large RollbackSegment
Roland Carlsson wrote:
>
> Hi!
> I have got a really large rollbacksegment. It's about twice the size of the
> rest of the database and have of some reason grown very quickly the last
> month. Is there a rollbackAll command I can do to be able to shrink the size
> of the databasefile??
>
> Thanks in advance
> Roland Carlsson
alter rollback segment XXX shrink;
alter database datafile '....' resize ... ;
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Thu Nov 15 2001 - 07:08:03 CST