Re: Clearing-out rollback_data

Try: alter rollback segment seg_name shrink; This command is available with 7.3+

Jim Lake <nospam_at_oceangarden.com> wrote in article >>
> 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?
>
  Received on Fri May 22 1998 - 08:00:23 CDT