-- TsMap.2.sql
-- ---------
--
-- This file lists some properties of a tablespace and its datafiles.
-----------------------------

select * from dba_tablespaces
 where Tablespace_Name = upper('&&tablespacename');

prompt The following datafiles comprise the tablespace:

column maxblocks    format 999,990
column user_blocks  format 999,990

select file_id
     , file_name
     , bytes/1048576 megs
     , blocks
     , maxblocks
     , user_blocks
  from dba_data_files
 where Tablespace_Name = upper('&&tablespacename');