How to: get Oracle database files location via PL/SQL query
You may use following query to get names and locations of database files: \n\n SELECT file_name,tablespace_name,bytes,blocks FROM dba_data_files ORDER BY tablespace_name,file_name Example of output you get: