Xref: alice comp.databases.oracle.server:39587 Path: alice!news-feed.fnsi.net!netnews.com!howland.erols.net!cpk-news-hub1.bbnplanet.com!cam-news-feed3.bbnplanet.com!news.gtei.net!sandoz-bh.sandgway.com!not-for-mail From: devinder Newsgroups: comp.databases.oracle.server Subject: Re: URGENT!! DATAFILE IN RECOVER Date: Tue, 02 Feb 1999 13:32:18 -0500 Organization: novartis Lines: 20 Message-ID: <36B744B1.B0281417@pharma.novartis.com> References: <78i2if$n60$1@nnrp1.dejanews.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Mailer: Mozilla 4.5 [en] (WinNT; I) X-Accept-Language: en Do a startup mount and then do alter database datafile 'your datafile' offline drop; mquesada@renault.com.ar wrote: > HI!, Iīm from argentina and my english is not good... I have a problem with a > datafile. I was trying to delete it when the database was open in archive log > mode. The datafile is in status RECOVER. The procedure that i used was: open > the storage manager, and select the datafile, and click in the red cross.. > then i made one more datafile in the same tablespace but i canīt use it > because Oracle is trying to insert in the datafile in recover. I need to > remove this datafile from my tablespace. The datafile was empty.. > > Thanks in advance... and sorry for my english ... > my email is mquesada@renault.com.ar > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own