Re: How to shrink undo space?

Roger Redford wrote:

> Dear experts,
>
> I'm discovering that 9i is a lot different than 8i.
> The 9i database I inherited had the undo tablespace's datafiles
> set to autoextend. This is turned off now. But, the
> unix file system is now at 99%, and this is causing alerts.
>
> In 8i, if the rollback tablespace was too big, for each
> rollback segment, you could just:
> alter rollback segment x shrink
> You could then resize the datafiles smaller.
>
> But, in 9i, with undo, I get:
>
> ERROR at line 1:
> ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
>
> If the parameter, undo_management, is set to MANUAL, is it
> possible to shrink use the shrink command, and then resize
> the datafiles?
>
> Thanks

Drop it and recreate with the parameters you want.

Daniel Morgan Received on Wed Feb 05 2003 - 12:41:42 CST