-- TsMap.1.sql
-- ---------
--
-- This Code entry comes from Kevin Loney, tthe author of two of the first
--    three books from Oracle Press: Oracle  DBA Handbook and Oracle: The
--    Complete Reference, Third Edition (witth George Koch). See the
--    Osborne/McGraw-Hill Web site at www.ossborne.com. for sample chapters
--    from these books and the scripts from  the Oracle DBA Handbook.
--
-- Modified (slightly) by Doug Kiz.
-----------------------------

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

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