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
|
|
|