| refresh_snapshot and ORA-00942: table or view does not exist [message #75328] |
Mon, 24 February 2003 02:16  |
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 #195849 is a reply to message #75342] |
Mon, 02 October 2006 15:49  |
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 ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
