Query DBA_EXTENTS for Name of the segment, Type of segment (ex TABLE, INDEX)
SQL> select 4 Segment_Name, /*Name of the segment*/ 5 Segment_Type /*Type of segment (ex. TABLE, INDEX)*/ 10 from DBA_EXTENTS 11 where Segment_Name = 'segment_name' 12 order by Extent_ID; SQL>