Re: analyze table

From: Ed Stevens <nospam_at_noway.nohow>
Date: Thu, 21 Aug 2003 12:08:29 -0500
Message-ID: <c3v9kvo2es69171cths1cfirrmc0esnafr@4ax.com>

On Thu, 21 Aug 2003 17:24:37 +0200, "Uwe Schmidt" <uwe.schmidt_at_dzsh.de> wrote:

>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 ???
>
>
>
>Thanks........
>

What is it you are trying to count? Received on Thu Aug 21 2003 - 12:08:29 CDT