Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Count rows
- Thread starter ofsouto
- Start date
flstffatboy
Technical User
- Sep 19, 2002
- 84
The following should produce a script you can run to get a count of all tables.
set pagesize 30000
spool xxxx
select 'select count(*) from '||table_name||';' from all_tables
set pagesize 30000
spool xxxx
select 'select count(*) from '||table_name||';' from all_tables
There are two problems here - (1) no "spool off" and (2) what happens if there is no synonym for the table. Try the following:
set pagesize 0
spool table_row_count
select 'select 'select '||''''||table_name||''''||', count(*) from '||owner||'.'||table_name||';' from dba_tables;
spool off
@table_row_count.lst
set pagesize 0
spool table_row_count
select 'select 'select '||''''||table_name||''''||', count(*) from '||owner||'.'||table_name||';' from dba_tables;
spool off
@table_row_count.lst
- Status
Similar threads
- Locked
- Question