Re: Large RollbackSegment

try this (as sys or system-user):

ALTER ROLLBACK SEGMENT "RBS10" OFFLINE;
--> "RBS10" is the name of *your* rollback segment ... DROP ROLLBACK SEGMENT "RBS10";
--> then you can shrink the tablespace/datafile on which the old rollback-segment have resided:
ALTER DATABASE DATAFILE 'C:\bla\bla\bla\RBS01.DBF'

    RESIZE 400M;
--> the size of 400M is an example!! however, you have to give another smaller size than the original size of the datafile...

hth
Rüdiger J. Schulz
rjs_at_berlin.de

"Roland Carlsson" <roland.c_at_swetravel.se> 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
>
>

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de