database

SELECT LOWER(owner) || '.' || LOWER(segment_name) AS "table_name",
       LTRIM(TO_CHAR(ROUND(SUM(bytes) / 1024 / 1024, 2), '999G999G999G990D00', 'nls_numeric_characters=''. ''')) || ' MB' AS "table_size"
FROM dba_segments
WHERE LOWER(segment_type)='table' AND
      LOWER(owner)='cuba' AND
      LOWER(segment_name) LIKE '%'
GROUP BY owner, segment_name
ORDER BY SUM(bytes) DESC;