set linesize 500
col file_name for a65
col tablespace_name for a25
col size(M) for 999999999
select file_name, tablespace_name, bytes/1024/1024 as "size(M)",autoextensible from dba_data_files
union all
select file_name, tablespace_name, bytes/1024/1024 as "size(M)",autoextensible from dba_temp_files order by 2,1
;

datafile.sql 查看数据文件和临时文件