Re: Error when Refreshing Materialized Views

Markus Boehmer wrote:

> 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

Suggestion: Believe the error message.
ORA-00942: table or view does not exist
Which referenced objects no longer exist?

Daniel Morgan Received on Fri Mar 28 2003 - 10:35:45 CST