Dropping undo datafiles while db up

  • From: "J. Dex" <cemail_219@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 26 Oct 2005 10:02:45 -0400

Is there anyway to drop datafiles from an undo tablespace while the database is up (running in noarchivelog mode)? Or, do you have to startup nomount and alter database drop datafile?

_________________________________________________________________
Don?t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/


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


Other related posts: