count tentr2

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