Re: Oracle10g, Need to find number of rows in each table in a schema

RA wrote:
> 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

And:

SELECT table_name, num_rows
FROM all_tables
[Quoted] WHERE owner = <some_value>;

won't work for what reason?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org