Re: how to shrink undo tablespace on 10GR2?

From: Yong Huang <>
Date: Wed, 20 Oct 2010 07:37:10 -0700 (PDT)
Message-ID: <>

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       

Received on Wed Oct 20 2010 - 09:37:10 CDT

Original text of this message