基表查询正常
SELECT * FROM oracle_catalog.SCOTT.EMP;
创建B库到A库的dblink
create database link test_link
connect to SCOTT identified by "Qazwsx1234"
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.23.28.17)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdb)
)
)';
创建emp表到testdb的同义词,查询正常
select * from emp@test_link;
create or replace synonym t_emp for scott.emp@test_link;
select * from t_emp;
在doris创建对应目录后,执行查询报表不存在
select * from oracle_test1.test1.t_emp;