Oracle View what objects the data file contains

In the previous Oracle view Tablespace object, I explained how to query a table space for those database objects, so can we have a data file that contains those database objects? As shown below

SELECT  as Segment_type

 as Segment_name

 as file_name

SUM  as Segment_size

 from Dba_extents E

INNER JOIN  on E.file_id= f.file_id

WHERE f.file_id =109

GROUP   by E.segment_type,e.segment_name,f.file_name

ORDER  by DESC;

SELECT  as Segment_type

 as Segment_name

 as file_name

SUM  as Segment_size

 from Dba_extents E

INNER JOIN  on E.file_id= f.file_id

WHERE F.file_name =&file_name

GROUP   by E.segment_type,e.segment_name,f.file_name

ORDER  by DESC;

The wrong wording, as shown below, Dba_segments's header_file represents the ID of the file containing the segment header, mainly because it contains only the files where the Chito of the segment object resides.

SELECT  as OWNER

 as file_name

 as Segment_name

 as Segment_type

,SUM as Segment_size

From

 Left JOIN  on DS. Header_file = df. file_id

WHERE ds. Tablespace_name=&tablespace_name

 and DF. file_id=&file_id

GROUP  by Owner,file_name,segment_name,segment_type

ORDER  by 4;

Oracle View what objects the data file contains