Oracle PL/SQL/System Tables Views/DBA DATA FILES

Query Data file Information

 
SQL>
SQL> select * from dba_data_files;   -- Data file Information
  2

Query DBA_DATA_FILES

 
SQL>
SQL> select File_Name, File_ID
  2    from DBA_DATA_FILES
  3   where Relative_FNO = 80;