首页 » ORACLE » ora-02069 global_names=false

ora-02069 global_names=false

when you try to access a table over the database link,mybe get this error

CREATE OR REPLACE FUNCTION ICME.todate (d VARCHAR2)
   RETURN DATE
IS
   v_date   DATE;
BEGIN
   SELECT TO_DATE (d, 'yyyy-mm-dd')
     INTO v_date
     FROM DUAL;

   RETURN v_date;
EXCEPTION
   WHEN OTHERS
   THEN
      RETURN NULL;
END;
/


update  ncme_study_credit@ncme set icme_mark=todate('1949-10-1')  where CREDIT_TYPE ='X2' AND USER_NAME='liqiao198458'

ORA-02069: global_names parameter must be set to TRUE for this operation

解决方法:
1,update ncme_study_credit@ncme set icme_mark=to_date(‘1949-10-1′,’yyyy-mm-dd’) where CREDIT_TYPE =’X2′ AND USER_NAME=’liqiao198458′
2, 把函数在远程数据库中
3,alter session/system set global_names=true
4,远程数据库创建一个和当前select * from global_name查询结果一样的同名database_link;

打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Tifany Suran | #1
    2011-12-21 at 04:48

    I like this web blog so much, saved to fav.