Dear Friends

I am having 10 Datafiles and these datafiles are attached with 3 Tablespace, 7 in the Main Tablespace and others are with Index tablespace.

Whenever I am seeing the space of the datafile in the DBA_DATA_FILES, it is showing all 10 datafiles, But whenever i am seeing Used Space of each datafile through the DBA_FREE_SPACE, then status of 2 Datafiles are not coming in the DBA_FREE_SPACE, Only Query show the 8 datafiles.

Can anyone tell me, How I can see the space of these 2 files and why it is not showing in the DBA_FREE_SPACE table.


Thanks in advance.

Sandeep