Re: How do we shrink UNDO tbs in 9i ?

Just want to know:
Why you need steps 3-5?
Why not leave the database with undo tablespace called UNDO2?

Adar Yechiel
Rechovot, Israel

Bala wrote:
>
> 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)
>

--
http://www.freelists.org/webpage/oracle-l