datafile_per_ts.sql

set lines 800
column file_name format a40
column tablespace_name format a20
select file_id, file_name, tablespace_name, (bytes / 1024 / 1024) as bytes_mb, (maxbytes / 1024 / 1024) as maxbytes_mb, autoextensible from dba_data_files where tablespace_name='&tsname';