Try this

Analyze all tables with compute option and then readout num_rows from all_tables

-----Original Message-----

From: chatrathi_at_hotmail.com [mailto:chatrathi_at_hotmail.com] Posted At: 17 September 1998 00:10
Posted To: misc
Conversation: Record count of all tables... Subject: Record count of all tables...

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 - 05:50:52 CDT