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

"Keith Kwiatek" <kkwiatek_at_nist.gov> wrote:

]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...

The reason it spits out errors is to inform you/us what is wrong. If you include the text of those errors we can give informed advice. Without the text of the errors all anyone can do is guess blindly.

check dba_data_files, dba_tablespaces to see what tablespaces were using that file, a tablespace can use more than one datafile.

You should then be able to offline drop the tablespace.

--
 ,-,_|\ George Dau - Unix (Solaris, DEC Unix, Linux), Oracle, Internet. __

/    * \ Home: gedau_at_pobox.com         !  Any views or opinions expressed (OO)
\_,--\_/ Work: gedau_at_isa.mim.com.au    !  above may be mine, but are NOT ( \/ )
      v   WWW: http://pobox.com/~gedau !  necessarily those of M.I.M.     W--W