oracle服务器没有建立目标数据库的tns时,在客户端(有权限的情况下)建立dblink语法如下:
复制代码 代码如下:
create database link dblink_name connect to user_name identified by user_psw using
‘(description =
(address_list =
(address = (protocol = tcp)(host = xxx.xx.xxx.xx)(port = 1521))
)
(connect_data =
(service_name = orcl)
)
)’