Re: how to shrink undo tablespace on 10GR2?

  • From: Yong Huang <yong321@xxxxxxxxx>
  • To: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
  • Date: Wed, 20 Oct 2010 18:02:25 -0700 (PDT)

> 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


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


Other related posts: