RIYOSU

select df.tablespace_name,ts.block_size,ts.initial_extent,ts.next_extent,
ts.min_extents,ts.max_extents,ts.pct_increase,ts.min_extlen,ts.status,ts.contents,
ts.logging,ts.force_logging,ts.extent_management,ts.allocation_type,ts.plugged_in,
ts.segment_space_management,ts.def_tab_compression,ts.retention,ts.bigfile,
df.file_name,df.file_id,df.bytes,df.blocks,df.status,df.relative_fno,
df.autoextensible,df.maxbytes,df.maxblocks,df.increment_by,df.user_bytes,
df.user_blocks,df.online_status
 from dba_tablespaces ts, dba_data_files df where
upper(ts.tablespace_name) like '%'
 and upper(df.file_name) like '%'
 and df.tablespace_name = ts.tablespace_name
union
select tf.tablespace_name,ts.block_size,ts.initial_extent,ts.next_extent,
ts.min_extents,ts.max_extents,ts.pct_increase,ts.min_extlen,ts.status,ts.contents,
ts.logging,ts.force_logging,ts.extent_management,ts.allocation_type,ts.plugged_in,
ts.segment_space_management,ts.def_tab_compression,ts.retention,'',
tf.file_name,tf.file_id,tf.bytes,tf.blocks,tf.status,tf.relative_fno,
tf.autoextensible,tf.maxbytes,tf.maxblocks,tf.increment_by,tf.user_bytes,
tf.user_blocks, ''
from dba_tablespaces ts, dba_temp_files tf where
upper(ts.tablespace_name) like '%'
 and upper(tf.file_name) like '%'
 and tf.tablespace_name = ts.tablespace_name
order by 1,2