List of DB objects in a datafile

set pages 1000
set lines 500
col owner format a20
col segment_name format a50
select distinct a.file_id,a.owner, a.segment_name,a.segment_type
from dba_extents a, dba_data_files b
where a.file_id=b.file_id
and b.file_name='/data/orcl/sysaux01.dbf';

Using the above query, we can find the following data:

Ø Owner                     - Schema owner

Ø file_id                      - Datafile number

Ø Segment_name   - DB object name

Ø Segment_type     - DB object type