ORA-00980 同义词转换不再有效(ORA-00980: synonym translation is no longer valid)
来源:互联网 发布:java聊天室实现原理 编辑:程序博客网 时间:2024/06/04 18:20
今天测试部在跑系统时,老是会报ORA-00980错误。发现同义词有问题。
同义词创建时,不会去检测内容的准确性,即如果表不存在,也可以创建该表的同义词,但是select时会报ORA-00980 同义词转换不再有效(ORA-00980: synonym translation is no longer valid)的错误。
Tom对此错误的解释:
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
TOM解释:http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7095288486502
- ORA-00980 同义词转换不再有效(ORA-00980: synonym translation is no longer valid)
- ORA-00980: synonym translation is no longer valid", version 9
- oracle 10g expdp ORA-00980: synonym translation is no longer valid
- ORA-00980: 同义词转换不再有效
- PL/SQL:ORA-00980同义词转换不再有效
- Error: PL/SQL: ORA-00980: 同义词转换不再有效
- dual表的恢复操作(ORA-00980:同义词转换不再有效错误解决(转) - rachel的日志 - 网易博客
- ORA-19588: archived log recid 181834 stamp 780173554 is no longer valid
- 同义词转换不再有效
- ORA-08103: object no longer exists
- ORA-8103 "object no longer exists"错误
- ORA-08103: object no longer exists
- ORA-16820: fast-start failover observer is no longer observing this database
- TRUNCATE SYNONYM & ORA-00942
- 同义词synonym
- 同义词(synonym)
- 同义词 synonym
- 不再摇滚 No longer Rock 'n' Roll
- 各种奇思妙想的怪异网站
- 2410开发板牛刀小试
- 深入剖析C#的多态
- Bad version number in .class file
- avi file structure
- ORA-00980 同义词转换不再有效(ORA-00980: synonym translation is no longer valid)
- ORA-22816
- 写给那些填报嵌入式专业的高中毕业生们
- 泛型算法系列30:stable_partition()&&partition()&&stable_sort()
- 【转】VC6.0 +WDK 开发驱动的环境配置
- DISTINCT关键字
- 修改makefile,为程序添加 build号和build日期
- 索引
- 正则表达式中的模式修正符