How do we shrink UNDO tbs in 9i ?
- From: Bala <oratips@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 Nov 2007 15:11:50 -0500
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
Other related posts:
