System Tables Views Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. System Tables Views
  4. 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>