Objetos por Tablespace - Oracle

select OWNER, SEGMENT_NAME, SEGMENT_TYPE
from dba_segments
where TABLESPACE_NAME='XXX';