While querying a view, got below error:

SQL> select * from DBA_SYN;
select * from DBA_SYN
ERROR at line 1:
ORA-00980: synonym translation is no longer valid


This error indicates that synonym is invalid , which is likely due to invalid dependent objects.

Lets check this below scenarios:

1. Create a public synonym for a table:

2. Metadata of the synonym:

3. Drop the dependent table(DBA_PART) and query the synonym:

— Query dependent objects of that synonym:

Now querying the synonym throwing ORA-00980: synonym translation is no longer valid error.Because the dependent object is missing.


When we get this error, we have to check the status of dependent object of that synonym. If this dependent object is missing or invalid, then take required action like compiling/recreating the object.