Re: How do we shrink UNDO tbs in 9i ?
- From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
- To: oratips@xxxxxxxxx
- Date: Fri, 16 Nov 2007 21:31:00 -0500
I'm 98% sure that will work.
The one caveat is that when you drop the undo1 tablespace you
drastically increase the risk of ORA-1555's for a little while.
Finn
On Nov 16, 2007 3:11 PM, Bala <oratips@xxxxxxxxx> wrote:
>
>
> Gurus,
>
> ORACLE 9.2.0.6 EE on Solaris
>
> Can I reduce the size of original undo tablespace (UNDO1) which has grown to
> 15 GB due to heavy import activity, by creating a
> second undo tablespace(UNDO2) and doing the following
>
> --
> 1) alter system set undo_tablespace = UNDO2;
> 2) Drop tablespace undo1 including contents and datafile;
> 3) create original undo tablespace undo1 with small size
> 4) alter system set undo_tablespace = UNDO1;
> 5) drop the second undo tablespace ( UNDO2)
> --
> would this work for 9.2.0.6 ?
>
> Thanks for your time
>
> Bala --
>
>
>
> --
> Bala Rao
--
//www.freelists.org/webpage/oracle-l
Other related posts:
