Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Dropping undo datafiles while db up

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US