How to: get Oracle database files location via PL/SQL query

You may use following query to get names and locations of database files:


SELECT file_name,tablespace_name,bytes,blocks

FROM dba_data_files

ORDER BY tablespace_name,file_name

Example of output you get:


Leave a Reply

Your email address will not be published. Required fields are marked *