Re: Conflict between dba_free_space and dba_datafiles for a new datafile

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Tue, 12 Jan 1999 17:06:19 +0800
Message-ID: <369B108B.150A@bhp.com.au>

m.L. wrote:
>
> Hello guys,
>
> I have a rather unique situation. It was about couple weeks
> ago that I added a second datafile for a particular tablespace, LDS
> at a client site. At the beginning, everything seems normal, but now
> I discovered that there is no entry for the new datafile (file_id =
> 17) in the table dba_free_space, while there is one in the
> dba_data_files. Would someone know similar situation?
>
> Objects like image files are constantly being added and
> deleted on the LDS tablespace. The 2nd datafile for LDS has been
> increased in size much faster than I expected. I suspect that the
> free space from deleted objects is not being used.
>
> If anyone has any ideas what I can do, or where should I
> check, please send me email to my company account mleung_at_intelus.com,
> or simply post it here.
>
> Thanks
> Michael L

This occurs when you have no free space left in this file...

The file still exists - thus it is in dba_data_files No free space chunks - thus it is not in dba_free_space

Cheers
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Tue Jan 12 1999 - 03:06:19 CST