Re: Undo Tablespace

You can create another undo tablespace,set parameter UNDO_TABLESPACE to the new undo tablespace,then drop the old one.

radian7 wrote:
> Hi
>
> I have oracle 9.2
>
> I use oracle in Automatic Undo Management Mode.
> Undo Tablespace have one file.
> That file is very big...
> How can I decrease size of that file ?
>
> Thanks
Received on Tue Jul 25 2006 - 09:35:42 CDT