ORA-00980: synonym translation is no longer valid
ORA-00980:同义词转换不再有效
TOM大师对该error的解释：http://asktom.Oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7095288486502
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
ops$tkyte%ORA11GR2> !oerr ora 980
00980, 00000, "synonym translation is no longer valid"
// *Cause: A synonym did not translate to a legal target object. This
// could happen for one of the following reasons:
// 1. The target schema does not exist.
// 2. The target object does not exist.
// 3. The synonym specifies an incorrect database link.
// 4. The synonym is not versioned but specifies a versioned
// target object.
// *Action: Change the synonym definition so that the synonym points at
// a legal target object.
query dba_objects and dba_users to see if there is another object/schema out there that overlaps the namespace please.
总而言之，TOM的意思是说该同义词已经失效。至于为什么失效，请看上面的解释。
我在使用DBlink的时候发生ORA-00980 synonym translation is no longer valid错误。我很疑惑，如果了解请告诉我，谢谢！
情况：
1）在PL/SQL 中写SQL语句insert into table (.....) select .... from view@dblink没有问题，能够正常执行，并且数据也可以插入。
2）在Procedure里把上述SQL写入后，编译时报错，ORA-00980 synonym translation is no longer valid。
3）我在本地数据库建立一个view, create or replace view XXX as select .....from from view@dblink,成功。
4)在procedure里的SQL修改为如下insert into table (.....) select .... from XXX，能够成功编译。
为什么？难道在procedure里不能用dblink来读取view吗？
我是通过创建中间视图，来解决过程编译报错00980的问题。如果有更好的方法解决该问题，请告知，谢谢！