Error when Refreshing Materialized Views

From: Markus Boehmer <markus.boehmer_at_schaefer-shop.de>
Date: Fri, 28 Mar 2003 11:49:42 +0100
Message-ID: <b61cgq$3lr$1@news.dtag.de>

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 - 04:49:42 CST