Re: RollBack Segments

From: Sebastian Bienkiewicz <bienkiew_at_bph.krakow.pl>
Date: Fri, 16 Oct 1998 08:45:51 +0200
Message-ID: <3626EB9F.DD7CF61D@bph.krakow.pl>

You can try to use ALTER ROLLBACK SEGMENT SHRINK - size of yours roll seg will be decreased to OPTIMAL parameter or you can (if you can :-) drop rollback segs tablespace & crate new one (and all roll segs too, o'course).

Bye,
Sebastian.

Jordan Redner wrote:
>
> I made the mistake of saying that my rollback segments are unlimited, and the
> storage devices that make up the rollback segments as well.
>
> Well - now I have an 800MB rollback segment.
>
> How can I start over? i.e. Wipe my current rollback segment/storage areas, and
> create a new one/ones?
>
> Any help is greatly appreciated.
>
> Thank you.
>
> Jordan
> jordan_at_merideo.com

--
no signature Received on Fri Oct 16 1998 - 01:45:51 CDT