如题
ORACLE中如何使用DBlink访问其他数据库。如何调用存储过程?求高人指点
------解决思路----------------------
create database link dblink_test
connect to 用户名 identified by 密码
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXX)(PORT = 1521)) )
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XX)))';
select * from 对象数据库中的表名@dblink_test