ORA-00980: synonym translation is no longer valid
975382Dec 12 2012 — edited Dec 13 2012oracle 11.2.0.1
SQL> select * from DBA_NETWORK_ACL_PRIVILEGES;
select * from DBA_NETWORK_ACL_PRIVILEGES
*
ERROR at line 1:
ORA-04063: view "SYS.DBA_NETWORK_ACL_PRIVILEGES" has errors
查找view DBA_NETWORK_ACL_PRIVILEGES的创建脚本，发现是视图XDS_ACE失效了
执行如下sql出现错误，可是XDB.XDB$ACL 是table，怎么会出现synonym出错呢
SQL> select EXISTSNODE (VALUE (b), '/ace/invert') from xdb.xdb$acl a,
2 table (XMLSEQUENCE (EXTRACT (a.object_value, '/acl/ace'))) b;
select EXISTSNODE (VALUE (b), '/ace/invert') from xdb.xdb$acl a,
*
ERROR at line 1:
ORA-00980: synonym translation is no longer valid