The error “ora-00980 synonym translation is no longer valid” received for a materialized view in one database. Through this article we will try to resolve the issue.
Index
Reason | Cause
There can be two reasons either the user doesn’t have the required privilege or the object it’s referring to doesn’t exist.
In our case, we have been hit 2nd case here. The synonym used is based on a table, view, or synonym that no longer exists.
Solution
Checking –
SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME='PRICE_AS400';
After that, we have checked for the underlying table, and surprisingly the table has been dropped.
We have then recreated the table (MV), and it started working properly.