Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Whoops! Deleted my db file before dropping tablespace! HELP!
*L* I did the same thing (ALSO a newbie) and got into a chicken-egg problem. I
couldn't drop the tablespace because it couldn't find the dbf file. I couldn't
THINK I tried alter database as suggested above but it didn't like that. I
know I tried making a dummy .dbf and it didn't like the header. Solution:
(You won't like it !) I dropped ALL .dbf, log files, ctl files, etc. and
recreated the database. It was a new one anyway. Obviously this is rarely a
good solution!
Good luck.
Mike
David Sisk wrote:
> Hi:
>
> You have to issue a "ALTER DATABASE DROP DATAFILE......". After you do
> this, it will let you drop the tablespace (if I remember correctly!)
>
> Good luck,
>
> --
> David C. Sisk
> The Unofficial ORACLE on NT site
> http://www.ipass.net/~davesisk/oont.htm
>
> Keith Kwiatek wrote in message <7av0ef$7o0$1_at_news.nist.gov>...
> >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
> >
> >
--