create tentr4

SELECT
t.owner,
t.table_name,
TO_NUMBER(EXTRACTVALUE(
XMLTYPE(DBMS_XMLGEN.GETXML(
'SELECT COUNT(*) AS c FROM "' || t.owner || '"."' || t.table_name || '"'
)),
'/ROWSET/ROW/C'
)) AS row_count
FROM
all_tables t
WHERE
t.owner = 'GLOBAL_COMET_US_1'
ORDER BY
t.table_name;