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>SQL>