建立数据库链接 create database link以及synonym
摘要:
--创建 CREATE public database link test_link CONNECT TO scott IDENTIFIED BY tiger using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = LEE) ) )'; --使用 select ename from emp@test_link; --删除 drop public database link 阅读全文
posted @ 2013-08-19 14:32 林尚轩 阅读(891) 评论(0) 推荐(0) 编辑