Oracle, Whoops! Deleted my db file before dropping tablespace! HELP!

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

Author	Message
Keith Kwiate #1 / 6	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

Doug Cowle #2 / 6	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

gremli #3 / 6	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

Matthias Oswal #4 / 6	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

Waterman Famil #5 / 6	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

Page 1 of 1

[ 6 post ]