创建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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/498744/viewspace-265191/ ，如需转载，请注明出处，否则将追究法律责任。
