Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-30432
Hello Leonard!
Thanks for yor answer.
I'm sure that my materilized view is ok. Particularly I can execute the
same select withot any error message
Moreover I've refreshed this view by DBMS_REFRESH.REFRESH (..) procedure. So
I think that
DBMS_MVIEW.REFRESH (..) procedure I've used before hase some misfunctions
Rgds, Vadim Grepan
Leonard F Clark wrote:
> Vadim,
>
> Some objects (e.g. procedures, functions, packages and views) can
> become invalid. For example, if you drop a table that is referenced
> in a view or procedure, then it becomes invalid. There can also be a
> chain of invalidity: if an object depends on another object which is
> invalid, then it too will become invalid.
>
> If view_author_count is one of the above you must recompile it. E.g.
>
> alter procedure view_author_count compile;
>
> I presume it is, in fact, a view in which case just re-create it.
>
> Len
>
> >Hello All!
> >
> > During refresh materialized view I've got error:
> >= = = =
> > ORA-30432: summary 'PROJECT.VIEW_AUTHOR_COUNT' is in INVALID
> >state
> >= = = =
> > What does it mean? I've searched over metalink and found nothing
> >
> >Rgds, Vadim Grepan
> >-------------------------
> >Moscow, Russia
> >
> >
Received on Sat Jul 21 2001 - 16:28:20 CDT