Oracle table tablespace
SELECT s.segment_name,
DECODE(SUM(BYTES), NULL, 0, SUM(BYTES) / 1024 / 1024) mbytes
FROM dba_segments s
WHERE s.segment_name = 'MTL_MATERIAL_TRANSACTIONS'
AND s.segment_type = 'TABLE'
GROUP BY s.segment_name