在Oracle 11g中DBLINK的创建以及测试

EMPLOYEE_ID FIRST_NAME
----------- --------------------
202 Pat

SQL> DELETE FROM EMPLOYEES
2 where FIRST_NAME='Pat';

1 row deleted.

SQL> commit;

Commit complete.

2)在主机上查看被连接数据库的hr用户下EMPLOYEES表
HR@ENMOEDU > select EMPLOYEE_ID,FIRST_NAME from EMPLOYEES@hrlink
2 where FIRST_NAME='Pat';

EMPLOYEE_ID FIRST_NAME
----------- --------------------
205 Shelley

至此，DBLINK创建成功。

Frank
2014.04.08

--To be continued--