Home » Server Options » Replication » ORA-12008: error in materialized view refresh path
ORA-12008: error in materialized view refresh path [message #75529] Mon, 09 August 2004 09:06
prash
Messages: 1
Registered: August 2004
Junior Member
Hi

I changed the db_link from which the snapshot gets the data. After that I get the following error.

The materialized view

ORA-12012: error on auto execute of job 224

ORA-12008: error in materialized view refresh path
ORA-00980: synonym translation is no longer valid
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
 
I executed the query present in the snapshot and it works fine.
Any clue on this?
 
prash
Previous Topic: Oracle Snapshot/ Job
Next Topic: how to refresh snapshot and materized views?
Goto Forum:
  


Current Time: Wed Apr 01 04:30:45 CDT 2020