Re: Drop invalid tablespace - how?

janet <janet_at_telesph.com> wrote:
>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

Hi there,

Try the following as SQLDBA internal user

drop tablespace <name> including contents;

This should drop the tablespace

Regards

N.Prabhakar Received on Sat Jan 11 1997 - 00:00:00 CST