Oracle查询表占用的空间

SELECT segment_name "表名",
       segment_type "对象类型",
       sum(bytes) / 1024 / 1024 "占用空间（MB）"
  FROM dba_extents
 WHERE segment_name = '表名'
 GROUP BY segment_name, segment_type;