ORA-00980: Synonym Translation Is No Longer Valid Leave a Comment / Oracle Database, ORA Error / By Database Analyser The error “ora-00980 synonym translation is no longer valid” received for a materialized view in one database. Through this article we will try to resolve the issue. Index ToggleReason | CauseSolutionReason | CauseThere can be two reasons either the user doesn’t have the required privilege or the object it’s referring to doesn’t exist.In our case, we have been hit 2nd case here. The synonym used is based on a table, view, or synonym that no longer exists.SolutionChecking –SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME='PRICE_AS400';After that, we have checked for the underlying table, and surprisingly the table has been dropped.We have then recreated the table (MV), and it started working properly. Views: 345Share this:Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Telegram (Opens in new window)Click to share on WhatsApp (Opens in new window)Like this:Like Loading...Related
