Re: Record count of all tables...

There are 2 easy ways to count rows from all tables:

1. Analyze all tables and query num_rows from all_tables
2. Use following query to create a script: select 'select '''||table_name||''',count(1) from '||table_name||';' from all_tables; spool the output to a file and run the spoolfile.

Hope this helps you out.

Robert.
rjungerius_at_yahoo.com

chatrathi_at_hotmail.com wrote in article <6tpggk$5ro$1_at_nnrp1.dejanews.com>...
> How can I get a record count of all the tables in the database ? We are
> essentially trying to figure out if an application upgrade scripts alters
> records in the database.
>
> Thanks in advance for your help...
>
> -Sriram
> chatrathi_at_hotmail.com
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Thu Sep 17 1998 - 06:51:34 CDT