oracle dblink

create database link  XXX
　　 connect to 数据库登陆名称 identified by  数据库登陆密码
　　 using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 数据库IP)(PORT = 1521))
    )
   (CONNECT_DATA =
      (SID = orcl)
      (SERVER = DEDICATED)
       (SERVICE_NAME = orcl)
    )
  )';
 
  select id,name From c_store@XXX  where id in (select id from c_store where id='1672');

 

insert  into C_STORE_CONTRAST (STOREID,CODE,NAME,BISCODE,BISTORENAME,id )
 select STOREID,CODE,NAME,BISCODE,BISTORENAME,id  from   C_STORE_CONTRAST@DBTEST2351

 

  
  select * From dba_db_links;