Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dba_free_space missing a tablespace???
It simply means you don't have free space in that tablespace.
It's not true that read only tablespaces or locally managed tablespaces will not show in dba_free_space.
Yong Huang
yong321_at_yahoo.com
In article <94n56a$g95$1_at_nnrp1.deja.com>,
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/
Received on Thu Jan 25 2001 - 12:27:41 CST