Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Analyzing materialized views?
Most likely you look up the wrong view. You find NUM_ROWS,
LAST_ANALYZED in *_tables, not *_mviews.
Rick Denoire <100.17706_at_germanynet.de> wrote in message news:<nblbruoi3i8git4prb461ga5lvpcl66pac_at_4ax.com>...
> Hello
>
> I know I can analyze materialized views and produce statistical data
> but I don't find the LAST_ANALYZED or NR_ROWS attributes of the
> corresponding objects. Did I get something wrong here?
>
> Oracle 8.1.7 / Solaris 2.7
>
> Thanks
> Rick
Received on Wed Oct 23 2002 - 00:15:20 CDT