Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>