Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>