Re: ORA-30432

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:27:26 CDT