What's the configuration of your MV environment? Did you set it up
through the replication package? Looks like some kind of privilige
problem. Try granting "select_catalog_role" to the user and see if the
problem goes away - does not mean this is a proper solution, but just
to prove a point. You can also do some event tracing to find out
exactly what statements are failing.
Markus Boehmer <markus.boehmer_at_schaefer-shop.de> wrote in message news:<b61cgq$3lr$1_at_news.dtag.de>...
> Error when Refreshing Materialized Views
>
> Hello everybody,
>
> I have a little Problem.
> Since we moved a few tables via import/export to our webserver in the
> internet, ran our script to rebuilt our types and materialized views
> our nightly db-job to refresh them all fails.
> Even a manually refresh brings the same messages.
>
>
> Here are the command and the error messages:
> declare
> nFailures binary_integer;
> begin
> DBMS_MVIEW.REFRESH_ALL_MVIEWS(nFailures, '?');
> end;
> /
>
> declare
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1325
> ORA-06512: at line 4
>
>
> I tried to rebuild the views...it hasn't worked.
>
> Then I ran catrep.sql again...it hasn't worked.
>
> I granted all necessary rights to the user wo shall refresh...it hasn't
> worked.
>
> I hope you have any suggestions.
>
> Greetings
> Markus
Received on Fri Mar 28 2003 - 12:02:54 CST
