SELECT DISTINCT a.file_id, a.segment_name, b.file_name
FROM (SELECT file_id, segment_name, extent_id
FROM dba_extents
WHERE segment_name = <TABLE_NAME>) a, dba_data_files b
WHERE a.file_id = b.file_id order by 1;
No comments:
Post a Comment