Thursday, 16 March 2017

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

Venkata GANNE

1 comment:

  1. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check