SQL> select * from global_name;
GLOBAL_NAME
-----------------------------
ARPDB41
2)创建与上述名字相同的dblink
create public database link ARPDB41
connect to 数据库用户
using '(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ip地址)(PORT=1521))
(CONNECT_DATA=
(SID=arpdb)
)
)';
第二种实践操作:
1)调整数据库参数global_names值为false
SQL> alter system set global_names=FALSE;
System altered.
SQL> show parameter global_name
NAME TYPE VALUE
------------------------------------ ----------- ----------
global_names boolean FALSE