Re: Tablespace dropped, How to remove from view?

In article <4s2m28$9ba_at_news.esrin.esa.it> James Dickson - SERCO <james> writes:

   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

Sorry about the earlier post - messed up my key bindings. The above mentioned problem (feature) is there for a reason. When a tablespace is dropped and recreated it reuses its previous entry if the name matches. This gives it the same tablespace number as in its previous incarnation. Tablespace quotas for users are joined on tablespace numbers and not dropped when a tablespace is dropped. Thus, if a tablespace is recreated (by export/import, etc) for any reasons, dbas do not have to reassign the quotas allocated to the various users on this tablespace. If a tablespace with that name is never recreated, the entry stays there but remains marked invalid.

bhaskar.

Disclaimer: All opinions mine and mine only. Received on Thu Jul 11 1996 - 00:00:00 CEST