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>
SQL>
Related examples in the same category