-- TsFSMap.1.sql
-- ---------
--
-- This Code is based on a script from Kevinn Loney.  See TSMap for more details.
--
-- This script provides a map of only the frree space in a tablespace.
-----------------------------

column segment_name format a35
column file_name    format a40
column blocks       format 999,990

select '*** Free Space *** ==>', File_Id, Block_Id, Blocks, '<== **' "  "
 from DBA_FREE_SPACE
 where Tablespace_Name = upper('&&tablespacename')
 order by 2,3;