Re: DataFile deleted ...

Do an alter database datafile 'path/filename' offline drop. That will let you then drop the tablespace, because Oracle won't be trying to checkpoint it.

If the delete (and drop) were unintentional, you would of course want instead to restore the relevant datfile, and then recover the database -assuming you have a decent recent backup, and all necessaary archive logs.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

<dinos5_at_yahoo.com> wrote in message news:8rnhoj$c6i$1_at_nnrp1.deja.com...


> Hi all,

>

> I delete a data file by mistake, before dropping the corresponding

> tablespace. Thus, I cannot drop the tablespace because Oracle cannot

> find the datafile.

> Which is the solution to that problem?

>

> thanks in advance

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.