ORA-00980: synonym translation is no longer valid tips

Home
E-mail Us
Oracle Articles
New Oracle Articles

Oracle Training
Oracle Tips
Oracle Forum
Class Catalog

Remote DBA
Oracle Tuning
Emergency 911
RAC Support
Apps Support
Analysis
Design
Implementation
Oracle Support

SQL Tuning
Security
Oracle UNIX
Oracle Linux
Monitoring
Remote support
Remote plans
Remote services
Application Server
Applications
Oracle Forms
Oracle Portal
App Upgrades
SQL Server
Oracle Concepts
Software Support
Remote Support
Development
Implementation

Consulting Staff
Consulting Prices
Help Wanted!

Oracle Posters
Oracle Books
Oracle Scripts
Ion
Excel-DB

Don Burleson Blog

ORA-00980: synonym translation is no longer valid tips

Oracle Error Tips by Burleson Consulting

The ORA-00980 synonym translation is no longer valid for a materialized view can happen when a user ID is the the same on the created the public synonym for a table.

See Oracle Note 38109.1 on MOSC.

You need to test the MV signed on as the same user who created the materialized view. You can also try creating a private synonym.

Oracle docs note this about ORA-00980:

ORA-00980 synonym translation is no longer valid

Cause: The synonym used is based on a table, view, or synonym that no longer exists.

Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym.

Oracle docs also has more information on ORA-00980 regarding invalid synonyms. Here, they reveal that the "ORA-00980: synonym translation is no longer valid" is a common error encountered in a development environment. This ORA-00980 error can happen for many reasons. Some of them are:

1. You created a synonym on non-existing object by mistake. For example, you created a synonym on SCOTT.DEPT where either the SCOTT schema in not present or the DEPT table is missing.

2. You dropped an object but you did not drop the synonyms referencing the object.

3. You dropped a user, but you did not drop synonyms referencing the objects owned by that user.

Keep in mind when reviewing your ORA-00980 situation that as objects become dropped the synonyms are not dropped and they remain until explicitly dropped.

��