Dropping undo datafiles while db up

From: J. Dex <cemail_219_at_hotmail.com>
Date: Wed, 26 Oct 2005 10:02:45 -0400
Message-ID: <BAY106-F2082A25BD2179F5BFE429BA5690@phx.gbl>

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/

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

Received on Wed Oct 26 2005 - 09:04:57 CDT