Re: dba_free_space missing a tablespace???

David Fitzjarrell wrote:
>
> 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.
> >
>
> Since DBA_FREE_SPACE lists the free space in all tablespaces could it
> be that there is no free space in APHRB1TS?

Is it possible that APHRBlTS is a read-only tablespace? If so, it would never have any free space.

..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................
..................................................