create database link KPHIS
connect to KPHIS
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.202.128.251)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
创建数据库链接如下。执行远程数据库报表的时候,select 的时候,速度超慢,没有任何的反应。是什么原因啊,单独登陆远程数据库都没有问题。
connect to KPHIS
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.202.128.251)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
创建数据库链接如下。执行远程数据库报表的时候,select 的时候,速度超慢,没有任何的反应。是什么原因啊,单独登陆远程数据库都没有问题。
create database link usdpdb
connect to usdpdb
identified by usdpdb
using 'usdpdb';
我这里用DBlink很快,哈哈
create database link /*DBLINK的名字*/ connect to /*用户名*/
identified by /*密码*/ using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = /*目标数据库IP*/)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = /*目标数据库SID*/) ) )';
这样看
create database link_KPHIS
connect to KPHIS identified by 密码
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.202.128.251)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';