Hi Gurus,

I am looking for a stored procedure or package to find total number of
rows in each table in a schema.

Something like, you can pass the schema name ot the SP or may be simple
query.

Thank you
RA

"janu" <angani (AT) gmail (DOT) com> a écrit dans le message de news: 1162579697.634588.94410 (AT) f16g200...oglegroups.com...
Set heading off
Set feedback off
Set pagesize 0
Set termout off
Set trimout on
Set trimspool on
Set recsep off
Set linesize 100
Column d noprint new_value date_
Spool tmp
Select 'Select '''||table_name||' : ''||count(*) from '||owner||'.'||table_name||';',
to_char(sysdate, 'YYYYMMDDHH24MISS') d
from dba_tables where owner=upper('&1')
order by table_name
/
Spool off
Spool count_&1._&date_
@tmp.LST
Spool off

Regards
Michel Cadot

On Nov 3, 2:00 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
Here is another example using pl/sql

Is there a simple way to produce a report of all tables in the database
with current number of rows ?
http://www.jlcomp.demon.co.uk/faq/count_all_rows.html

HTH -- Mark D Powell --