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

  • March 16, 2017 | 21 views
  • Comments