SELECT t.tablespace_name,
	ROUND(SUM(bytes / (1024 * 1024)), 0) ts_size
	FROM dba_tablespaces t,
	dba_data_files d
	WHERE t.tablespace_name = d.tablespace_name
	GROUP BY t.tablespace_name;