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:

script_output

Please follow and like us:

Leave a Reply

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