How to get a ROW count of all Tables in Oracle DB

[dejohnny]

Another row count Oracle:

Select ‘Select ”’||owner||’.'||table_name||’ , ”||count(*) from ‘||owner||’.'||table_name ||’;',
to_char(sysdate, ‘YYYYMMDDHH24MISS’) d, user u
from all_tables
where owner not in (‘SYS’, ‘SYSTEM’)
order by table_name

OR

select table_name, num_rows, blocks from user_tables order by num_rows desc;