Re: rows in dba_free_space for system tablespace

check out the view description in the docs and look carefully at the data exposed by the view

you'll find there's one row for each free extent in each tablespace -- check out the concepts manual and dba manual on how oracle manages tablespaces and disk allocation

• mcs

"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
|
|
|
|
|
|
Received on Thu Nov 20 2003 - 05:18:52 CST