How do we shrink UNDO tbs in 9i ?

From: Bala <oratips_at_gmail.com>
Date: Fri, 16 Nov 2007 15:11:50 -0500
Message-ID: <9ea7ad870711161211w1c11dfccnd3b5dc865d1f6c44@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 16 2007 - 14:11:50 CST