Re: Conflict between dba_free_space and dba_datafiles for a new datafile

On Tue, 12 Jan 1999 17:06:19 +0800, Connor McDonald <mcdonald.connor.cs_at_bhp.com.au> wrote:

>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
>Connor McDonald
>BHP Information Technology

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?

mike Received on Tue Jan 12 1999 - 23:18:58 CST