Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> what is this? and where can I learn more about it?
SPOOL slave.sql
SELECT 'SELECT' ||''''table_name''''||', COUNT(*) FROM '||table_name||';'
FROM user_tables
/
SPOOL table.lst
@slave
SPOOL OFF
Received on Wed Aug 01 2001 - 12:43:25 CDT