ERROR ORA -00980 Synonym Translation no longer valid

Error Message : ORA -00980 Synonym Translation no longer Valid.

Error Area : it is related Database (Table/view) not related to forms

When it happens : Synonym is in inconsistent state, in my case i have modified the view on which synonym was created (dependent) .

How to confirm the issue : when query the data using the synonym in TOAD/sqldeveloper ….. it shows error message ORA -00980 Synonym Translation no longer valid.

Action Plan/solution: drop the synonym and recreate synonym(after the base view/table modified)

verify: Query the data by using the synonym then it should fetch the data

By
Venkata GANNE

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.