Drop invalid tablespace - how?

Hi all,

     probably a stupid question...but...

     we're currently running 7.0.

     i did a select from dba_tablespaces and found one that i know we don't use. the name appears to be a typo. the status is invalid.

     if i query dba_data_files, there is no corresponding data file for the tablespace.

     if i say drop tablespace X, it says that the tablespace does not exist (0959). (i know i typed the name right.)

     it's not a big problem, just an annoyance, but i should be able to rid us of this nonexistent tablespace, right? how?

thanks
janet Received on Fri Jan 10 1997 - 00:00:00 CST