Re: Tablespace dropped, How to remove from view?

In <4s2m28$9ba_at_news.esrin.esa.it>, James Dickson - SERCO <james> writes:
>Christoph Karpeter wrote:
>> Cathy Fischer wrote:
>>>
>>> I have dropped a tablespace and shutdown and re-started the database but when
>>> I query the DBA_TABLESPACES view that tablespace still shows up. It has a
>>> status of INVALID. Why is it there? Is there anyway to get rid of it?
>>
>> looks like V6. If you are using Oracle V6, don't bother about it. It WILL
>> remain there, you can't remove it. The good news about it? In ORACLE7, it
>> works properly.
>> regards
>> christoph
>
>In the Oracle 7 Server Administrator's Guide, chapter 7, page 18,
>it says: "after a tablespace is dropped the tablespace's entry
>remains in the data dictionary in the DBA_TABLESPACES view, but
>the tablespace's status is changed to INVALID."
>
>On this basis the problem (feature?) is still there in at least
>the early versions of Oracle 7.
>
>James
>

tried it out in 7.3 and it works !! the entry is removed.

Bye,
Steve

| any similarity 'tween my opinions and that |
|  of my employers are purely hypothetical   |
|     and should give no cause for alarm     |
 --------------------------------------------