Whoops! I deleted my db file! help! 
Author Message
 Whoops! I deleted my db file! 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! I deleted my db file! help!

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

The reason it spits out errors is to inform you/us what is wrong. If you include
the text of those errors we can give informed advice. Without the text of the
errors all anyone can do is guess blindly.

check dba_data_files, dba_tablespaces to see what tablespaces were using that
file, a tablespace can use more than one datafile.

You should then be able to offline drop the tablespace.

--
 ,-,_|\  George Dau - Unix (Solaris, DEC Unix, Linux), Oracle, Internet.   __


      v   WWW: http://pobox.com/~gedau !  necessarily those of M.I.M.     W--W



Sat, 11 Aug 2001 03:00:00 GMT
 Whoops! I deleted my db file! help!

Hi Keith,

Don't be panic ! It won't do you harm at all if you take my advice seriously.
first, try to issue: ALTER TABLESPACE <your ts-name> OFFLINE IMMEDIATE;
if fail, shut it down (the database), and then issue :
STARTUP MOUNT
ALTER DATABASE DATAFILE '/oracle data file loction and filename' OFFLINE DROP;
SHUTDOWN NORmAL;
STARTUP OPEN;

see?
 easy indeed !!

John Koo

: 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! I deleted my db file! help!
John,

thanks that did the trick!

Keith



Sun, 12 Aug 2001 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. delete offline DB doesn't delete files?

2. DELETE FILE doesn't delete the file

3. SQL 2000 Server failure to delete old db backup files

4. ldf file deleted- db won't work

5. DB Mtce Plan does not delete old files

6. [SQL] Re: why the DB file size does not reduce when 'delete'the data

7. ALERT: BDE Error $2303 on WinNT/Tutility, and DB-file deleted

8. ALERT: BDE Error $2303 on WinNT/Tutility, and DB-file deleted

9. SQL DB to File...File to SQL DB???

10. Restore two DB file into four DB file

11. Delete Queries - Changing the name of DELETED.DB

12. OLE DB prov in MDAC 2.6/2.7 causes SS2000 to not run deletes properly - help


 
Powered by phpBB® Forum Software