---DBLink创建语法及使用:
语法:
create public database link dblinkname connect to username identified by password
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = database_ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =servicename)
)
)';
实例:
create public database link ma_test connect to test identified by test
using '10.163.91.121:1521/TEST';
使用:
select * from username.tablename@dblinkname;
---同义词创建语法及使用:
语法:
create synonym synonymName for username.tablename@dblinkname;
实例:
create synonym atest for test.atest@ma_test;
使用:
SELECT * FROM atest;