Show all Oracle Datafiles in a Tablespace dba_data_files

SQL query to show all the Oracle Datafiles that are in a Tablespace:

set lines 200
column file_name format a69
select file_name,tablespace_name,bytes / (1024 * 1024) "Size (MB)",autoextensible, maxbytes,increment_by
from dba_data_files
where tablespace_name like '&tbs' order by file_name ;

Leave a Reply

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