dblink

--创建全局的dblink
要附上权限才行的。

SQL>conn system/pwd;
SQL>grant create database link to username;
SQL>create public database link faq1 connect to faq identified by faq using 'faqOnline';



--创建单独的dblink
SQL>create database link faq1 connect to faq identified by faq using 'faqOnline';


------------------建在205.86上面--------------------------
create database link synchWorkId
  connect to faq identified by faq
  using
  '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.241.73)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = chbak)
    )
  )';
 
  select * from faq.t_sys_user@SYNCHWORKID t where t.work_id='9999';
  update  faq.t_sys_user@SYNCHWORKID t set t.real_name='测试9999' where t.work_id='9999';