select
table_name,
to_number(
extractvalue(
xmltype(
dbms_xmlgen.getxml('select count(*) c from '||table_name))
,'/ROWSET/ROW/C')) count
from
user_tables
order by
table_name;
select owner, table_name,
'select count(*) from '||table_name||';'
from dba_tables
where owner = 'DB_DESIGNER';
select
table_name,
num_rows counter
from
dba_tables
where
owner = 'XXX'
order by
table_name;