Did you use the 'REUSE' clause when the rollback tablespace was
created? This may be the problem. HTH
>
> Problem
> We are running 7.0.15 and are having problems with rollback segments.
> They extend but will not reduce to 'optimal' again. The database runs
> out of rollbacks and has to be bounced to clear it. The rollback
> segment must be dropped to free the space.
>
> What is the problem ?
> does anyone have a fix that does not entail bouncing the database
> (i.e. shutting down and starting up again)
>
> thx
>
> ian stewart
>
Received on Tue Jan 16 1996 - 11:00:19 CST
