Re: analyze table

"Uwe Schmidt" <uwe.schmidt_at_dzsh.de> wrote in message news:<newscache$ib6zjh$738$1_at_www-neu.dzsh.de>...
> hello ng,
>
> i would like to generate an output of the form:
>
>
> table_name - num_rows (by analyze table) - last-analyzed - count(*) from
> now
>
> i'm dealing with dba_tables and select count(*) from ......
>
>
> But i can't get an sql-script, which generates all in one.
>
> So, has anybody an idea ????
> Perhaps in PL/SQL ???

Search for "selstat.sql" on metalink to help you get going.

jg

--
@home.com is bogus.
Tiger was a cat.  Biff was a dog.  Anything named after a ferret?