oracle创建DBlink

（1）在sys用户下，把CREATE PUBLIC DATABASE LINK，DROP PUBLIC DATABASE LINK权限授予给你的用户
　　grant CREATE PUBLIC DATABASE LINK，DROP PUBLIC DATABASE LINK to yhjypt;
（2）
create database link kmsicp3_link
  connect to kmsicp3 identified by kmsicp3    using '
      (DESCRIPTION = 
          (ADDRESS_LIST = 
              (ADDRESS = 
                 (PROTOCOL = TCP)
                 (HOST = 192.168.5.5)
                 (PORT = 1521)) ) 
              (CONNECT_DATA = 
                  (SERVICE_NAME = ORCL)
         ) )';


grant CREATE PUBLIC DATABASE LINK，DROP PUBLIC DATABASE LINK to yhjypt;
　
create database LINK yb_link
  connect to kmsicp3 identified by kmsicp3   using '
      (DESCRIPTION = 
          (ADDRESS_LIST = 
              (ADDRESS = 
                 (PROTOCOL = TCP)
                 (HOST = 192.168.5.5)
                 (PORT = 1521)) ) 
              (CONNECT_DATA = 
                  (SERVICE_NAME = ORCL)
         ) )';
create database LINK yb_link