Thanks for favourable reply
when i try out above query it shows zero rows(no such file id) ,so i have excute without where clause and got




FILE_ID FILE_NAME TABLESPACE_NAME
-------------------------------------------------------------------------------------
1 E:\ORACLE\ORADATA\DISUPE\DISUPE\SYSTEM01.DBF SYSTEM
2 E:\ORACLE\ORADATA\DISUPE\DISUPE\UNDOTBS01.DBF UNDOTBS1
3 E:\ORACLE\ORADATA\DISUPE\DISUPE\CWMLITE01.DBF CWMLITE
4 E:\ORACLE\ORADATA\DISUPE\DISUPE\DRSYS01.DBF DRSYS
5 E:\ORACLE\ORADATA\DISUPE\DISUPE\EXAMPLE01.DBF EXAMPLE
6 E:\ORACLE\ORADATA\DISUPE\DISUPE\INDX01.DBF INDX
7 E:\ORACLE\ORADATA\DISUPE\DISUPE\ODM01.DBF ODM
8 E:\ORACLE\ORADATA\DISUPE\DISUPE\TOOLS01.DBF TOOLS
9 E:\ORACLE\ORADATA\DISUPE\DISUPE\USERS01.DBF USERS
10 E:\ORACLE\ORADATA\DISUPE\DISUPE\XDB01.DBF XDB
11 E:\WINDIS\DISUPE\DATA\DISUPEMST.ORA DISUPEMST
12 E:\WINDIS\DISUPE\DATA\UPEDISTDATA07.ORA DISTDATA07