ora-01017 ora-02063 database link,oracle11.2g通过dblink连接oracle11.2g

来源:互联网 发布:导弹惯性制导难度知乎 编辑:程序博客网 时间:2024/06/11 15:47

错误图示:

图示

问题解决

All database links, whether public or private, need username/password of the remote/target database. Public db links are accessible by all accounts on the local database, while private db links are only accessible in the schema they are defined in. So, as suggested earlier, if you drop your public database links and recreate them exactly as you did for the fprchr account (CREATE PUBLIC DATABASE LINK …. CONNECT TO … IDENTIFIED BY … USING …) then your queries will work using any account on the local database.
图示
也就是以public创建dblink就解决了。

0 0
原创粉丝点击