You can do it in a simpler way thru SQL*Plus
Step 1. Generate a script to analyze the tables in the schema
spool ana_table.sql
select 'analyze table '||tname||' estimate statistics sample 20 percent'
from tab
/
spool off

Step 2.
Analyze the tables in the schema
@ana_table.sql

Step 3.
Create table result_tab
(table_name,
num_rows,
num_blocks,
last_upd_date)
as
(SELECT table_name,
num_rows,
blocks,
SYSDATE
FROM dba_tables
WHERE owner = (schema_name))
/