Re: Whoops! I deleted my db file! help!

FYI, I ran into this same situation, and John's suggestion did not work for me. Following the startup mount, the alter database command failed due to "database not open". My only recourse was to shutdown, restore an old copy of the missing datafile, then startup and let Oracle do it's media recovery, then drop the tablespace, shutdown and remove the datafile again...

-Roy-

In article <7avv8l$n1n64_at_news.hk.linkage.net>,   johnkoo_at_whale.i-wave.net (John Koo) wrote:
>
> Hi Keith,
>
> Don't be panic ! It won't do you harm at all if you take my advice seriously.
> first, try to issue: ALTER TABLESPACE <your ts-name> OFFLINE IMMEDIATE;
> if fail, shut it down (the database), and then issue :
> STARTUP MOUNT
> ALTER DATABASE DATAFILE '/oracle data file loction and filename' OFFLINE DROP;
> SHUTDOWN NORmAL;
> STARTUP OPEN;
>
> see?
> easy indeed !!
>
> John Koo
> johnkoo_at_i-wave.net
>
> Keith Kwiatek (kkwiatek_at_nist.gov) wrote:
> : Hello Guru person,
 

> : I am a newbie...I wanted to drop a test tablespace I was playing with, but I
> : deleted the oracle data file before I issued the "drop tablespace"
> : command.... Now when I try to "drop tablespace" it spits out a bunch of
> : errors...
 

> : How do I clean this up?
 

> : Thanks!
 

> : Keith
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 25 1999 - 00:00:00 CET