ORA-00980: Synonym Translation Is No Longer Valid

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.

ORA 00980 Synonym Translation Is No Longer Valid

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.

Leave a Comment

Your email address will not be published. Required fields are marked *