System Tables Data Dictionary Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. System Tables Data Dictionary
  4. Query DBA_EXTENTS for Tablespace name,Owner of the segment
SQL>  select
  2        Tablespace_Name,   /*Tablespace name*/
  3        Owner             /*Owner of the segment*/
 10   from DBA_EXTENTS
 11  where Segment_Name = 'segment_name'
 12  order by Extent_ID;
SQL>