Solved

ORA-00980: synonym translation is no longer valid

Posted on 2003-11-24
5
3,823 Views
Last Modified: 2012-06-21
I was running my c++ application in windows NT
operating system and oracle 7.3 and it worked fine.

I recently updated my Oracle to 9i in Windows 2000 to my new machine. After Imported the database from my old machine to a new one my application wrote in C++ no longer work and it gave me following error.


ERROR: CDBException Generated.
ORA-00980: synonym translation is no longer valid Option value changed.
Please close and Restart Application.


0
Comment
Question by:davidh515
  • 2
5 Comments
 
LVL 12

Accepted Solution

by:
catchmeifuwant earned 125 total points
ID: 9816098
From Oracle Docs
-----------------

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.

********************************************
1)Identify the synonyms that are being used in the code and recreate them..

If you had a synonym called S_EMP to the table emp,then :

create public synonym S_EMP for SCOTT.EMP;

0
 
LVL 3

Expert Comment

by:patelgokul
ID: 9816111
0
 
LVL 12

Expert Comment

by:catchmeifuwant
ID: 9969907
Lunchy,

What is that supposed to mean???
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle 12c patching 1 87
help on oracle query 5 45
su - oracle could not open session 6 79
Why  don't I see Below columns in my  Stored Procedure  under TMP_RS? 8 22
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question