Re: dba script

In article <83b3al$44a$1_at_nnrp1.deja.com>, Erik Cotsonas <cotsonas_at_my-deja.com> wrote:
> 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]

 hi Erik,
thanks 4 replyin..
can the above script b more automised by takin the owners from ALL_USERS
bye..

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!