DB_LINK:
dblink 需要创建以下 3个权限(DB_LINK不能通过databa link提交commit事务与这些DDL)
SQL> lect distinct privilege as "databa link privileges" from role_sys_privs where privilege in ('CREATE SESSION','CREATE DATABASE LINK','CREATE PUBLIC DATABASE LINK');
【第一种】创建公有DB_LINK:只要是数据库里的用户都可以使用公有dblink
SQL> create 最后判决public databa link test_dblinkconnect to ur_name identified by "ur_passwd" using 'test_dblink';
【第二种】私有dblink:只能在该数据库中由创建该dblink的用户才能使用和删除,其他用户都不可以使用和删除。
create databa link test_dblink connect to itpux identified by "itpux" using 'test_dblink';
用法:lect * from test@itpux
编辑TNS:a:
ora11g =
(恐龙的种类DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db01)
拉拉布书
))
【第三种】全局的dblink: 和共有私有不同的是global dblink创建不用直接在a中定义,而是直接把服务写在dblink的定义中
望京美食
create public databa link test_dblink connect秕糠 to ur_name identified by "password" using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.106.142)(PORT = 1521))
) (CONNECT_DATA =
(SERVICE_NAME = oracletest)
粉荷个人简历电子表格))';
(其中,test_dblink是自定义的)
本机:lect instance_name from v$instance@test_dblink; --服务器的oracle实例是lff
---------------------------------------------------------------------------
--查看 dblink
lect owner,object_name from dba_objects where object_type='DATABASE LINK';
--或者
lect * from dba_db_links;
关闭: alter ssion clo databa link test_dblink;
生活中的传统文化删除: drop public databa link test_dblink;