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

]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

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

thanks that did the trick!

Keith