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

Query Data file Information

   <source lang="sql">

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

 2
  
 </source>
   
  

Query DBA_DATA_FILES

   <source lang="sql">

SQL> SQL> select File_Name, File_ID

 2    from DBA_DATA_FILES
 3   where Relative_FNO = 80;
  
 </source>