Search This Blog

ora-00980 synonym translation is no longer valid

synonym translation is no longer valid

oracle sql


Cause: The synonym used is based on a table, view, or synonym that no longer exists.
Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym.
Oracle docs also has more information on ORA-00980 regarding invalid synonyms.  Here, they reveal that the “ORA-00980: synonym translation is no longer valid” is a common error encountered in a development environment. This ORA-00980 error can happen for many reasons. Some of them are:
1. You created a synonym on non-existing object by mistake. For example, you created a synonym on SCOTT.DEPT where either the SCOTT schema in not present or the DEPT table is missing.
2. You dropped an object but you did not drop the synonyms referencing the object.
3. You dropped a user, but you did not drop synonyms referencing the objects owned by that user.
Keep in mind when reviewing your ORA-00980 situation that as objects become dropped the synonyms are not dropped and they remain until explicitly dropped.

No comments:

Post a Comment

comments are welcome