Table Name...........Row_Count in a particular User

Getting Row_Count of all tables in a particular User

execute dbms_stats.gather_schema_stats ('scott');


select table_name, num_rows from user_tables order by table_name;