Re: Conflict between dba_free_space and dba_datafiles for a new datafile

Home -> Community -> Usenet -> c.d.o.misc -> Re: Conflict between dba_free_space and dba_datafiles for a new datafile

From: MarkP28665 <markp28665_at_aol.com>
Date: 13 Jan 1999 22:18:17 GMT
Message-ID: <19990113171817.18391.00000184@ng-cd1.aol.com>

From: mleung_at_earthlink.net >>
I thought about that as well, but I would expect an entry in the dba_free_space with zero bytes. Are you suggesting that Oracle actually will delete all the entries in the dba_free_space of a datafile when it is full? <<

Yes, no entry will appear for a tablespace in sys.dba_free_space if there are no free extents.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Wed Jan 13 1999 - 16:18:17 CST