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
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
Good Blog, Thanks For Sharing This Informative article.
ReplyDeleteOracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad