QYERY PARA SABER TAMANHO EM MB DE TABELAS

SELECT ds.tablespace_name

      ,segment_name

      ,round(SUM(ds.bytes) / (1024 * 1024)) AS mb

  FROM dba_segments ds

 WHERE segment_name IN (SELECT table_name

                          FROM dba_tables

                          WHERE OWNER = OWNER–‘USUARIO’

                          )

 GROUP BY ds.tablespace_name

         ,segment_name;