RE: Num of rows of all tables in a database...

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Thu, 21 Sep 2000 09:34:22 -0400
Message-Id: <10626.117565@fatcity.com>

This just does one schema, just change user_ to dba_ for all tables.

set pages 200
set heading off
set feedback off
spool do_count.sql
select 'select count(*) as ' || table_name || ' from ' || table_name || ';' from user_tables;
spool off
set heading on
@do_count
set feedback on

-----Original Message-----
From: Anjan Thakuria [mailto:Anjan.Thakuria_at_sabre.com] Sent: Wednesday, September 20, 2000 6:56 PM To: Multiple recipients of list ORACLE-L Subject: Num of rows of all tables in a database...

Hi Listers,

Does any body have a script that gives you the number of rows of each table in a
database that has not been analyzed in a while.

TIA Anjan

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Anjan Thakuria
INET: Anjan.Thakuria_at_sabre.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 21 2000 - 08:34:22 CDT