How to get table present in datafile in oracle database

 How to get table present in datafile in oracle database

COLUMN owner FORMAT A15

COLUMN segment_name FORMAT A30

COLUMN segment_type FORMAT A20

COLUMN tablespace_name FORMAT A20

COLUMN file_name FORMAT A40

SELECT DISTINCT e.owner, e.segment_name, e.segment_type, e.tablespace_name, f.file_name FROM dba_extents e INNER JOIN dba_data_files f ON e.file_id = f.file_id WHERE f.file_name in (file_names);

You can get file_name using

set linesize 190

col tablespace_name for a30

col file_name for a30

select tablespace_name,FILE_NAME from dba_data_files.