Mega Code Archive
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>
SQL>