sql语句如下:
create database link BI
connect to dw identified by dwdahua
using ‘(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.111.40)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dwdb)
)
)’;
在Oracle client 里面正常执行结果如下图
但在oceanbase developer center里面执行错误如下: