Re: Whoops! Deleted my db file before dropping tablespace! HELP!

I think if you take the tablespace off line, and then drop the tablespace including contents,
you might be all right? Not sure. Never done it. (also a newbie)

Keith Kwiatek 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
Received on Wed Feb 24 1999 - 13:03:50 CST