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: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Fri, 28 Mar 2003 16:45:30 GMT
Message-ID: <3E847B6B.36BBFE5B@telusplanet.net>


DA Morgan wrote:

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

Or is in another schema and does not have appropriate access permissions.

Suggest you try 'SELECT count(*) from tab;' or 'select table_name from all_tables where table_name = "tab"' for the list of tables that make up the MV. Do this from the user that should own the MV. (Verify that views are valid as well.) If one or more table/view does not exist or have missing permissions, you expect this message. If all do exist and all are accessible from the proper user (not the owning user) then you might want to discuss with Oracle.

> Daniel Morgan

/Hans Received on Fri Mar 28 2003 - 10:45:30 CST

Original text of this message

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