Re: Drop Tablespace Problem

For the groups information I've discovered more info today, while there is still a problem with the catalog I now know why the tablespace row was not disappearing from dba_tablespaces.

In both 7.0xx and 7.3xx (so presumably 7.1xx and 7.2xx) a drop tablespace does leave a row in sys.ts$ and much to my surprise the definition of dba_tablespaces has changed in 7.3 to explicitly exclude "deleted" tablespaces. Take a look at sys.ts$, dropped tablespaces have a "value" of 3 in the column online$ from ts$ (actually you have to process the value in online$, so look at the definition of dba_tablespaces in 7.3.

I'd be interested to see when this was changed as frankly I don't remember dropped tablespaces still appearing in dba_tablespaces in 7.0xx (but it was a long time ago). Right now I am feeling a little embarrassed at this as I was sure that the tablespaces were removed from dba_tablespaces view when they were dropped. Received on Mon Jun 02 1997 - 00:00:00 CDT