To find the ROW Counts of tables that belongs to a Particular Schema

Share
select table_name,num_rows counter from dba_tables where owner=’Schema_name’ order by table_name;
Share

Tags: , , , , , ,