数据库连接 DB_LIKE
访问远程数据库资源的一种方法
确保网络畅通
create public database link ts connect to scott identified by seker using 'orcl'
create public 公共的访问模式
database link ts 连接名称
connect to scott 连接用户名
identified by seker 用户密码
using 'orcl' orcl是tnsname.ora中的定义
SQL> conn / as sysdba
Connected.
SQL> create public database link ts connect to scott identified by seker using 'ORCL';
Database link created.
SQL> conn scott/seker
Connected.
SQL> select ename,sal from emp where ename='SCOTT';
ENAME SAL
---------- ----------
SCOTT 3000
SQL> select ename,sal from emp@ts where ename='SCOTT';
ENAME SAL
---------- ----------
SCOTT 3000
SQL> update emp@ts set sal=sal+1 where ename='SCOTT';
1 row updated.
SQL> select ename,sal from emp where ename='SCOTT';
ENAME SAL
---------- ----------
SCOTT 3000
SQL> select ename,sal from emp@ts where ename='SCOTT';
ENAME SAL
---------- ----------
SCOTT 3001
SQL>
查看数据库连接
col OWNER for a10
col USERNAME for a10
col host for a10
col created for a10
SQL> select owner,username,host,created from dba_db_links;
OWNER USERNAME HOST CREATED
---------- ---------- ---------- ----------
PUBLIC SCOTT ORCL 02-APR-11
SQL>
删除
SQL> drop public database link ts;
Database link dropped.
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24756465/viewspace-717788/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24756465/viewspace-717788/