Re: rows in dba_free_space for system tablespace

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 20 Nov 2003 03:19:37 GMT
Message-ID: <dpWub.653$eX2.222@news01.roc.ny>

"sarab" <sarabjeetd_at_hotmail.com> wrote in message news:IVUub.9373$Br7.8531_at_news.cpqcorp.net...
> Hi,
> Why are there multiple rows for system tablespace in dba_free_space? There
> is only one data file configured for the system tablespace.
>
> Oracle 9i.
>
> regards
> -sarab
>

Its telling you the chunks of free space that are present in that data file. i.e. chunks of free space between the chunks of used space :)

Anurag Received on Wed Nov 19 2003 - 21:19:37 CST

This message: [ Message body ]
Next message: mcstock: "Re: Getting two fields from the one table."
Previous message: mcstock: "Re: Question and suggestion regarding rownum"
In reply to: sarab: "rows in dba_free_space for system tablespace"
Next in thread: mcstock: "Re: rows in dba_free_space for system tablespace"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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