Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Error when Refreshing Materialized Views
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