ORA-00980是Oracle数据库中的一个错误代码,表示“synonym translation is no longer valid”(同义词翻译不再有效)。这意味着你尝试访问的同义词所指向的对象(如表、视图、序列等)已经不存在、无法访问或同义词本身的定义已经过时。 2. 导致ORA-00980错误的常见原因 对象被删除:同义词所引用的数据库对象(如表、视图...
4.imp 正式环境导出的dmp档 5.在测试环境底下explain plan sql时报:ORA-00980: synonym translation is no longer valid 用以下语句查下失效的synonym select 'drop ' || decode (s.owner, 'PUBLIC', 'public synonym ', 'synonym ' || s.owner || '.') || s.synonym_name || ';' as "Dropping ...
一、先来模拟一下这个“ORA-00980: synonym translation is no longer valid”错误。 1.在secooler用户中创建一张表t secooler@ora10g> create table t (x number); Table created. secooler@ora10g> insert into t values (1); 1 row created. secooler@ora10g> commit; Commit complete. 2.切换到sec用户...
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 ...
select sysdate from dualORA-00980: synonym translation is no longer valid 这种问题也比较常见,一般都是在sys下面重建就可以。 但是仔细一看, 原来是有人在自己的用户下面,建了同名的dual。 删了,一切正常。 估计是有人在上面做什么测试。 SQL> drop synonym dual;Synonym dropped...
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later: When Trying to Compile Package body dbms_xplan gives error ORA-00980: synonym translation is no lo
ORA-00980: synonym translation is no longer validORA-00980：同义词翻译不再有效,.原因：同义词未...
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: The target schema does not exist. The target object does not exist. The synonym specifies an incorrect database link. ...
同义词转换不再有效ORA-00980: synonym translation is no longer valid,同义词创建时,不会去检测内容的准确性,即如果表不存在,也可以创建该表的同义词,但是select时会报ORA-00980同义词转换不再有效(ORA-00980:synonymtranslationisnolongervalid)的错误。解决:发现
ORA-00980:synonymtranslationisnolongervalid。 同义词转换不再有效。 同义词创建时,不会去检测内容的准确性,即如果表不存在,也可以创建该表的同义词,但是select时会报ORA-00980同义词转换不再有效(ORA-00980: synonym translation is no longer valid)的错误。