SELECT file_name FROM dba_data_files
  WHERE file_id IN
    (SELECT file_id FROM dba_extents
       WHERE owner='SCOTT'
          AND segment_name='EMP'
          AND segment_type='TABLE');
