Oracle创建DBLink和同义词

---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 forusername.tablename@dblinkname;

实例：

create synonym atest  for test.atest@ma_test;

使用：

SELECT * FROM atest;