【原创】ORA-02085问题的解决

创建database link

sys@ORCL>create database link fgos connect to fgos identified by fgos using 'FGOS';

Database link created.

通过database link查询远程数据库，报ORA-02085错误

sys@ORCL>select * from dual@fgos;
select * from dual@fgos
                   *
ERROR at line 1:
ORA-02085: database link FGOS.REGRESS.RDBMS.DEV.US.ORACLE.COM connects to FGOSDB

发现global_names是true（在访问远程数据库时会自动添加.REGRESS.RDBMS.DEV.US.ORACLE.COM ）

sys@ORCL>show parameter glglobal_names

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- -------
global_names                         boolean                          TRUE

将global_names改为false后问题解决

sys@ORCL>alter system set global_names=false;

System altered.

sys@ORCL>select * from dual@fgos;

D
-
X