tcount

SELECT
t.owner || '.' || t.table_name AS full_table_name,
XMLCAST(
XMLQUERY('/ROWSET/ROW/C/text()'
PASSING XMLTYPE(DBMS_XMLGEN.GETXML(
'SELECT COUNT(*) AS C FROM ' || t.owner || '.' || t.table_name))
AS NUMBER) AS row_count
FROM all_tables t
WHERE t.owner IN ('GLOBAL_COMET_US_1', 'GLOBAL_COMET_US_2', 'GLOBAL_COMET_US_3', 'COMET_US_REF')
ORDER BY 1;