在使用创建好的dblink访问用户表中数据的时候出现如下错误:
select * from ztry.ztry_jbxx@ztryora-00604: error occurred at recursive SQL level 1
ora-20099: Login closed,please connect to dba
ora-06512: at line7
ora-01031: insufficient privilegss
ora-02063: 紧接着 4 line (起自 ZTRY_FW)
select * from ztry.ztry_jbxx@ztryora-00604: error occurred at recursive SQL level 1
ora-20099: Login closed,please connect to dba
ora-06512: at line7
ora-01031: insufficient privilegss
ora-02063: 紧接着 4 line (起自 ZTRY_FW)
ora-06512: at line7
ora-01031: insufficient privilegss你是不是AS SYSDBA登陆~~~~~~~~权限问题啊~~
权限不足
先到本地服务器,用连接的用户select下
应有更明确的提示