ORA-00980: synonym translation is no longer valid", version 9

 
You Asked
1.在数据库中的概念 同义词（synonym）是指向其它数据库表的数据库指针。
Hi Tom,

  I run Oracle 7.3 for years in Window NT machine with an C++ application and it work
fine.

  I recently updated my Oracle to 9i in Windows 2000 to my new machine (different
machine).  After Imported the database from my old machine to a new one my application
wrote in C++ no longer work and came up with an error

*********
ERROR:
CDBException Generated.
ORA-00980: synonym translation is no longer valid
Option value changed.

Please close and Restart Application.

***************

Thanks. your answer is greatly appreciated.

David
 

and we said...
that means you lost some object/access to some object when you did your move.  That error
simply means "synonym is still here, but the object it points to is inaccessible".  It
could be inaccessible due to a missing grant, or due to the object not being there.

You need to find out what synonym it is, query the data dictionary to figure out what
object it points to and figure out why you no longer have access to that object.

ops$tkyte@ORA920> create synonym s for t;
Synonym created.

ops$tkyte@ORA920> select * from s where rownum = 1;

C
----------
1

ops$tkyte@ORA920> drop table t;
Table dropped.

ops$tkyte@ORA920> select * from s where rownum = 1;
select * from s where rownum = 1
              *
ERROR at line 1:
ORA-00980: synonym translation is no longer valid

 
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7095288486502