1 Reply Latest reply: Dec 13, 2012 6:33 AM by LiuMaclean(刘相兵) RSS

    ORA-00980: synonym translation is no longer valid

    975382
      oracle 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