Free Space of datafile

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

What is the status of the files in DBA_DATA_FILES?

Is it possible that the two that are not showing in DBA_FREE_SPACE have a different status? Just a guess.

Good luck.

Dear Sir,

Status for all datafiles are AVAILABLE in DBA_DATA_FILES.


Thanks

Sandeep

Sorry about that.

What is the status of the files in V$DATAFILE? Could 2 of them be OFFLINE?

those two files might be 100% full and then they won't show up in dba_free_space