ORACLE中如何找出大表分布在哪些数据文件中？

SET PAGESIZE 60;

COL SEGMENT_TYPE FOR A12;

COL FILE_NAME FOR A64;

COL SEGMENT_NAME FOR A24;

COL TABLESPACE_NAME FOR A24;

COL SEGMENT_OWNER FOR A12;

SELECT E.OWNER                    AS SEGMENT_OWNER, 

       E.SEGMENT_TYPE             AS SEGMENT_TYPE, 

       E.SEGMENT_NAME             AS SEGMENT_NAME, 

       E.PARTITION_NAME           AS PARTITION_NAME, 

       E.TABLESPACE_NAME          AS TABLESPACE_NAME, 

       F.FILE_NAME                AS FILE_NAME, 

       SUM(E.BYTES) / 1024 / 1024 AS SEGMENT_SIZE 

INNER JOIN DBA_DATA_FILES F ON E.FILE_ID= F.FILE_ID

WHERE         E.OWNER='&OWNER'

        AND E.SEGMENT_NAME='&SEGMENT_NAME'

GROUP BY E.OWNER

        ,E.SEGMENT_TYPE

        ,E.PARTITION_NAME

        ,E.SEGMENT_NAME

        ,E.TABLESPACE_NAME

        ,F.FILE_NAME

ORDER BY SEGMENT_SIZE DESC;