Whoops! Deleted my db file before dropping tablespace! HELP! 
Author Message
 Whoops! Deleted my db file before dropping tablespace! HELP!
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



Sat, 11 Aug 2001 03:00:00 GMT
 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)
Quote:

> 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



Sun, 12 Aug 2001 03:00:00 GMT
 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

Quote:

> 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


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

--
-----------------------------------------------------
To reply to me via email, remove the "__NO_SPAM__" in
the header email address.
-----------------------------------------------------


Wed, 15 Aug 2001 03:00:00 GMT
 Whoops! Deleted my db file before dropping tablespace! HELP!
Hi all,

I too did made this error once. ALTER DATABASE will work, but you have to be in
startup mount (or maybe nomount)
for the command to work.

Ken

Quote:

> *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


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


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

> --
> -----------------------------------------------------
> To reply to me via email, remove the "__NO_SPAM__" in
> the header email address.
> -----------------------------------------------------

--
Regards,

Matthias Oswald                                       Eurocontrol - CFMU


Tel:  +32 2 729 96 89                               B-1130 Bruxelles
Fax: +32 2 729 90 22                               Belgium



Tue, 21 Aug 2001 03:00:00 GMT
 Whoops! Deleted my db file before dropping tablespace! HELP!
Another little known option which I have had to use before is to re-create
the missing datafile as an empty substitute for the deleted file.  Use the
following command:
    ALTER DATABASE CREATE DATAFILE disk1:users1 AS disk2:users1;

This will provide the database with a genuine, albeit empty, datafile that
replaces the deleted file.  If the file was just deleted, chances are good
you can recover from the redo logs.  If you archive your redo logs, you can
definately recover the file from them.  Even with just an empty file in
place, you can drop the tablespace when the database is in exclusive mode.
    --Gary

Quote:

>Hi all,

>I too did made this error once. ALTER DATABASE will work, but you have to
be in
>startup mount (or maybe nomount)
>for the command to work.

>Ken


>> *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


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


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

>> --
>> -----------------------------------------------------
>> To reply to me via email, remove the "__NO_SPAM__" in
>> the header email address.
>> -----------------------------------------------------

>--
>Regards,

>Matthias Oswald                                       Eurocontrol - CFMU


>Tel:  +32 2 729 96 89                               B-1130 Bruxelles
>Fax: +32 2 729 90 22                               Belgium



Fri, 24 Aug 2001 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. 8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

2. Deleted .dbf file instead of drop tablespace ...

3. Help - accidentally deleted tablespace file

4. Drop datafile from rollback tablespace without shutdown DB.

5. Dropping tablespace (zero-block tablespace)

6. Dropping tablespace (create zero-block tablespace)

7. restore tablespace backup after DROP tablespace (UDB 5.2)

8. Whoops! I deleted my db file! help!

9. Problem with dropping tablespaces w/o .dbf files

10. Drop file from SYSTEM tablespace

11. Drop a data file from a tablespace

12. how to drop a data file from a tablespace


 
Powered by phpBB® Forum Software