Home » Server Options » Replication » refresh_snapshot and ORA-00942: table or view does not exist
refresh_snapshot and ORA-00942: table or view does not exist [message #75328] Mon, 24 February 2003 02:16 Go to next message
Guy Rassabi
Messages: 10
Registered: February 2003
Junior Member
Hello

The refresh process was working fine for couple of days and then with no particular reason the Refresh process return an error message:

08:42:23 dw_prod@dwprod>exec dbms_mview.refresh('STATUS_REP');
begin dbms_mview.refresh('STATUS_REP'); end;

*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 654
ORA-06512: at line 1

Do you have any ideas?
Did u solve the problem?

The table is exists with the same permission as yesterday...
I work with DBLink that has not been change and work fine with other Mviews

Thanks in advance

Guy Rassabi
Re: refresh_snapshot and ORA-00942: table or view does not exist [message #75342 is a reply to message #75328] Tue, 18 March 2003 06:53 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Enable SQL TRACE for your session (ALTER SESSION SET SQL_TRACE = TRUE;) and inspect the output to get the name of the table it complains about.

Best regards.

Frank
Re: refresh_snapshot and ORA-00942: table or view does not exist [message #195849 is a reply to message #75342] Mon, 02 October 2006 15:49 Go to previous messageGo to next message
abhishekk.ranjan
Messages: 1
Registered: October 2006
Location: San Francisco
Junior Member
Hi I am facing the same problem where I am not able to refresh materialized view , I am getting following error :

BEGIN dbms_mview.refresh('STCH_MV','C','',TRUE,FALSE,0,8,0,FALSE); END;

*
ERROR at line 1:
ORA-30439: refresh of 'STCH_MV' failed because of ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 841
ORA-06512: at line 1

The compile state of mv in user_mviews is needs_compile and status of mv in all_objects is 'invalid'.
In last run the refresh was successful and I have not changed any setup of mviews between last and current run.

Please let me know why error occurs and how to solve it ?
Re: refresh_snapshot and ORA-00942: table or view does not exist [message #475461 is a reply to message #75328] Wed, 15 September 2010 04:33 Go to previous message
karlb
Messages: 1
Registered: September 2010
Junior Member
I could solve an occurance of this problem by calling
ALTER MATERIALIZED VIEW my_mview COMPILE;
before refreshing the mview. But I do not know why this was necessary in this case.
Previous Topic: Bi-Directional Replication through Golden Gate
Next Topic: Database migration in multi master replication
Goto Forum:
  


Current Time: Thu Mar 28 14:37:15 CDT 2024