Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Error when Refreshing Materialized Views

Re: Error when Refreshing Materialized Views

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Fri, 28 Mar 2003 08:35:45 -0800
Message-ID: <3E8479E1.46B2E3A3@exxesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US