Re: how to shrink undo tablespace on 10GR2?
From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 20 Oct 2010 18:02:25 -0700 (PDT)
Message-ID: <825773.37599.qm_at_web80605.mail.mud.yahoo.com>
> Drop the original undo tablespace:
>
> DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;
>
> Especially on Windows, you might find the datafiles associated with
> the undo tablespace remain on disk. If so, restart the instance:
Date: Wed, 20 Oct 2010 18:02:25 -0700 (PDT)
Message-ID: <825773.37599.qm_at_web80605.mail.mud.yahoo.com>
> Drop the original undo tablespace:
>
> DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;
>
> Especially on Windows, you might find the datafiles associated with
> the undo tablespace remain on disk. If so, restart the instance:
How could that be possible? DROP TABLESPACE failed with an error?
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 20 2010 - 20:02:25 CDT