Re: dba script

From: Erik Cotsonas <cotsonas_at_my-deja.com>
Date: Thu, 16 Dec 1999 16:17:31 GMT
Message-ID: <83b3al$44a$1@nnrp1.deja.com>

Save the following as a script and execute it through sqlplus

[snip]
set pagesize 0
set linesize 1000
set trimspool on

SPOOL tblCounts.tmp

select 'SELECT RPAD(''' || owner || '.' || table_name || ': '', 50) || COUNT(*) FROM ' || owner || '.' || table_name || ';' from dba_tables
where owner in ('NTEX', 'ECOTSONAS')
order by owner, table_name;

SPOOL off

@tblCounts.tmp

[snip]

Erik

In article <106d149e.911676ac_at_usw-ex0107-049.remarq.com>, narayan <narayan_raykarNOnaSPAM_at_engineer.com.invalid> wrote:
> hi guys..
> can u help me with a script that will
> give me the
> no of records in each table of each user within a database.
>
> i have 6 users and 151 tables for each user.
> help me out on this
> narayan
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
Network *
> The fastest and easiest way to search and participate in Usenet -
Free!
>
>

--
Erik
Consultant
Saraswati Systems Corporation - (SSC)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 16 1999 - 10:17:31 CST