Re: dba_free_space missing a tablespace???

In our last gripping episode Ed Stevens <ed.stevens_at_home.com> wrote:
> Here's an odd one. I SELECT DISTINCT TABLSPACE_NAME from 3 different
> views: dba_tablespaces, dba_data_files, and dba_free_space. I should
> get the same results, but look at the following, and you'll see that
> dba_free_space returned one less tablespace name . . . .
>
> SQL> select tablespace_name
> 2 from dba_tablespaces
> 3 order by tablespace_name;
>
> TABLESPACE_NAME
> ------------------------------
> APHDTATS
> APHIDXTS
> APHRB1TS
> APHRB2TS
> APHTMPTS
> SYSTEM
>
> 6 rows selected.
>
> SQL> select distinct tablespace_name
> 2 from dba_data_files
> 3 order by tablespace_name;
>
> TABLESPACE_NAME
> ------------------------------
> APHDTATS
> APHIDXTS
> APHRB1TS
> APHRB2TS
> APHTMPTS
> SYSTEM
>
> 6 rows selected.
>
> SQL> select distinct tablespace_name
> 2 from dba_free_space
> 3 order by tablespace_name;
>
> TABLESPACE_NAME
> ------------------------------
> APHDTATS
> APHIDXTS
> APHRB2TS
> APHTMPTS
> SYSTEM
>
> 5 rows selected.
>
> SQL> spool off
>
> --
> - Ed Stevens
>
> Sent via Deja.com
> http://www.deja.com/
>

Since DBA_FREE_SPACE lists the free space in all tablespaces could it be that there is no free space in APHRB1TS?

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/