Re: Drop invalid tablespace - how?

janet wrote:

> 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?

When you get 'invalid' status of a tablespace from 'dba_tablespaces', it means that tablespace was dropped. But Oracle will keep a trace on that table unless you recreate another tablespace with the same name.

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049