Re: how to shrink undo tablespace on 10GR2?
- From: Yong Huang <yong321@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Wed, 20 Oct 2010 07:37:10 -0700 (PDT)
The recommended way to "shrink" an undo tablespace in AUM is as others
said, create a new one and assign undo_tablespace to it.
If you work with Oracle support, they may allow you to set
"_smu_debug_mode" to 4 and either shrink an undo segment, or offline
and drop it. Just another option to keep in mind, even though it's
probably more work.
Yong Huang
--
//www.freelists.org/webpage/oracle-l
Other related posts:
