Count the number of rows for ALL tables in current schema

Run the following script:

-----------------------

set termout off echo off feed off trimspool on head off pages 0
spool on
spool C:\countall.txt
select 'SELECT count(*), '''||table_name||''' from '||table_name||';'
from   user_tables
/
spool off


-----------------------

Thanks.
NJ