Re: dba script

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Thu, 16 Dec 1999 12:41:09 GMT
Message-ID: <83aml6$qm8$1@nnrp1.deja.com>

Use the following in a text file and execute in each user schema.

SET HEADING OFF
SET PAGESIZE 0
SET TERMOUT OFF
SET FEEDBACK OFF
SET TRIMSPOOL ON
SPOOL batch_sql.sql
SELECT 'SELECT ''' || RPAD(TNAME,30) || ''' , COUNT(*) FROM ' || tname || ';' from tab;
SPOOL OFF
SET TERMOUT ON
SET HEADING ON
@@batch_sql.sql

regards,
M. Armaghan Saqib

SQL PlusPlus : Add power to SQL Plus command line
SQL Link for XL : Integrate Oracle with XL
Oracle CBT with sample GL (Triggers and Forms Source Code included. Download free: http://www.geocities.com/armaghan/
narayan <narayan_raykarNOnaSPAM_at_engineer.com.invalid> wrote in message news:106d149e.911676ac_at_usw-ex0107-049.remarq.com...
> 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 via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 16 1999 - 06:41:09 CST