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

From: Satar <satar_at_my-dejanews.com>
Date: Tue, 09 Mar 1999 20:14:24 GMT
Message-ID: <7c3ven$vjc$1@nnrp1.dejanews.com>

First do a:
alter database datafile '/oracle/oradata/ora7/dummy01.dbf' offline drop;

Then:
drop tablespace dummy;

E-mail me if you want me to give you a detailed step by step instructions.

Regards,
Satar

Oracle DBA/UNIX System Admin
"Opinions are the result of the voices in my head only, and do not reflect my employer or Oracle Corporation."

In article <7av0ef$7o0$1_at_news.nist.gov>, "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 Tue Mar 09 1999 - 14:14:24 CST