Re: Big rollback_data

Depends upon what version of Oracle you are using check out the documentation for the Optimal clause for rollback segments. This will allow the database to shrink the rollback segment to a pre-determined size after use.

HTH Colin.

Jim Lake wrote in message <3564A8DD.7D19DD1D_at_oceangarden.com>...
>I have a very static database, updated only once monthly. My
>rollback_data tablespace has grown very large. How do I clear it out? Do
>I drop rollback segments, or the whole tablespace?
>
>Thanks in advance for any advice and examples,
>
>Jim Lake
>
Received on Fri May 22 1998 - 19:35:42 CDT