ORA-00980: synonym translation is no longer valid

ORA-00980:同義詞轉(zhuǎn)換不再有效

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的意思是說該同義詞已經(jīng)失效。至于為什么失效，請看上面的解釋。

我在使用DBlink的時候發(fā)生ORA-00980 synonym translation is no longer valid錯誤。我很疑惑，如果了解請告訴我，謝謝！

情況：

1)在PL/SQL 中寫SQL語句insert into table (.....) select .... from view@dblink沒有問題，能夠正常執(zhí)行，并且數(shù)據(jù)也可以插入。

2)在Procedure里把上述SQL寫入后，編譯時報錯，ORA-00980 synonym translation is no longer valid。

3)我在本地數(shù)據(jù)庫建立一個view, create or replace view XXX as? select .....from from view@dblink,成功。

4)在procedure里的SQL修改為如下insert into table (.....) select .... from XXX，能夠成功編譯。

為什么？難道在procedure里不能用dblink來讀取view嗎？

我是通過創(chuàng)建中間視圖，來解決過程編譯報錯00980的問題。如果有更好的方法解決該問題，請告知，謝謝！

總結(jié)

以上是生活随笔為你收集整理的oracle 00980,ORA-00980如何解决的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。