我用如下dblink:在数据库a中,建立连接create public database link AA
connect to b identified by "1"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orcl )
)
)';我想在数据库b中查询a的表,为何会报ora-02063 紧接着line 的错误呢?
是只能从a中查b的表吗?单向查询?数据库dblink
connect to b identified by "1"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orcl )
)
)';我想在数据库b中查询a的表,为何会报ora-02063 紧接着line 的错误呢?
是只能从a中查b的表吗?单向查询?数据库dblink
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货