To see all objects in a table space file | Oracle DBA Tutorial pdf

To see all objects in a table space file

SELECT
D.OWNER,D.SEGMENT_NAME,D.SEGMENT_TYPE,D.TABLESPACE_NAME,
D.HEADER_FILE,V.NAME
FROM
Dba_Segments D
JOIN V$DATAFILE V ON (D.HEADER_FILE=V.FILE#)
WHERE
D.OWNER IN ('MKM')