Re: Urgent!!! Datafile In Recover...

First off, your English is fine. Don't be self-conscience.

Let me point out to you, that you cannot simply delete datafiles that you don't want. My suggestion to you is not a good one, it is applying a bandage to an open flesh wound. Anyway, take the datafile offline. Your applications will not be able to access the information that is held on this datafile (if any). With the datafile offline, you will be able to open the database and add datafiles to that tablespace.

If you have a valid backup, I would highly suggest that you recover this datafile or recover the database into a point of time prior to its creation.

Regards,
Satar
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

In article <78iedo$1a6$1_at_nnrp1.dejanews.com>,   mquesada_at_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..
> Im running oracle 7.3.4.1 on HP-UX 11...
>
> Thanks in advance... and sorry for my english ...
> my email is mquesada_at_renault.com.ar
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 25 1999 - 15:36:16 CST