Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dba_free_space missing a tablespace???

Re: dba_free_space missing a tablespace???

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 25 Jan 2001 18:08:12 -0000
Message-ID: <94pq2e$gdj$1@soap.pipex.net>

I would have thought that in this situation you should get an entry with either null or zero in the appropriate columns. I haven't actually tried this though tablespaces with no free space being something to avoid....

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"David Fitzjarrell" <oratune_at_aol.com> wrote in message
news:94n5fl$gej$1_at_nnrp1.deja.com...

> 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/
Received on Thu Jan 25 2001 - 12:08:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US