Row count for all tables in an Oracle Schema

Row count for all tables in an Oracle Schema

http://www.etload.com/2013/03/counts-of-all-tables-in-schema.html

Fist method:- 




select table_name,
       to_number(extractvalue(xmltype(dbms_xmlgen.getxml('select count(*) c from '||owner||'.'||table_name)),'/ROWSET/ROW/C')) as count
from all_tables
where owner = 'EDW'


Second Method:-
May not give you the correct results some time 

select
   table_name,
   num_rows counter
from
   ALL_tables or DBA_TABLES
where
   owner = 'EDW'
order by
   table_name;




Third Method:-

Declare
    v_count integer;
begin

    for x in (select table_name, owner from all_tables
              where owner = 'SCHEMA_NAME')
    loop
        execute immediate 'select count(*) from ' || x.table_name
            into v_count;
        INSERT INTO Table_Counts(TABLE_NAME,SCHEMA_NAME,RECORD_COUNT,CREATED)
        VALUES (x.table_name,x.owner,v_count,SYSDATE);
    end loop;

end;