Re: how to shrink undo tablespace on 10GR2?
From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 20 Oct 2010 07:37:10 -0700 (PDT)
Message-ID: <869758.85096.qm_at_web80607.mail.mud.yahoo.com>
The recommended way to "shrink" an undo tablespace in AUM is as others said, create a new one and assign undo_tablespace to it.
Date: Wed, 20 Oct 2010 07:37:10 -0700 (PDT)
Message-ID: <869758.85096.qm_at_web80607.mail.mud.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 20 2010 - 09:37:10 CDT