Re: Record count of all tables...

Keep in mind that the count will not tell you if any rows were altered, only net differences in adds or deletes. Don't you trust the application, Sriram? Can you sfford the disc space to run another instance of the database and compare the two afterward (a time-consuming job).

ed prochak

In article <01bde231$607b2540$270164bf_at_wks139>,   "Robert Jungerius" <rjungerius_at_death-to-spam.cetecint.com> wrote:
> 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
> >
>

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702

-----== 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 - 10:06:13 CDT