Saturday, September 18, 2010

Find how many different files is table spread across?

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