Re: Calling all the SQL Guru's

That thing was full of typos, lets try again :

set pagesize 0;
spool count.sql;
select 'select count(*), ''' || owner || '^' || table_name || ''' from '||owner||'.'|| table_name||' union ' from all_tables where owner not in ('SYS', 'SYSTEM');
spool off;

You will then have to edit 'count.sql' to change the word 'Union' on the last line to a ';', then run count.sql.

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 09 2001 - 12:12:21 CST