Thanks for the reply. I was thinking the same thing. Needed the confirmation from an experienced person. One more query...

Even though I have droped the data file, I am able to see the droped file in the dba_data_files. Why it is not getting removed from this view?
Tablespace had two datafiles and one is corrupted/unavailable now.
In which table/view this inconsistency is recorded ?

Regards,
Ajith