Re: Clearing-out rollback_data

Thanks Richard, but my problem is not the rollback segments, it's the tablespace, rollback_data. I am able to manage the segments ok, but I want to reduce the size of the tablespace.

Thanks for your help, Jim.

Richard Wilson wrote:
>
> Jim,
>
> Try setting the optimal parameter for the rollback segments, this will
> cause the segments to shrink after they have reached the specified size. I
> think your problem is that when you update the rollback segments grow and
> maybe your rollback tablespace is set to autoextend so if your maxextents
> for rollback segments is high, they will continue to grow.
>
> Richard
>
> Jim Lake <nospam_at_oceangarden.com> wrote in article
> <3564A710.A56CF872_at_oceangarden.com>...
> > I have a very static data warehouse, only updated once monthly. My
> > rollback_data tablespace has grown, and I see no need for it's contents.
> > How can I clear it out? Do I drop rollback segments?
> >
> > Thanks in advance for any advice and examples,
> >
> > Jim Lake.
> >
> >

Received on Mon May 25 1998 - 15:17:21 CDT