日期:2014-05-16  浏览次数:20390 次

oracle跨服务器复制表
CREATE PUBLIC DATABASE LINK linktest CONNECT TO som IDENTIFIED BY som USING '(DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 10.38.95.230)(PORT = 1521))
     )
     (CONNECT_DATA =
(SERVICE_NAME =testdb)
     )
   )'
   
   
 insert into dm_fielddict (Fieldname,Fieldtype,Fieldlen,Numfloat)  
 SELECT Fieldname,Fieldtype,Fieldlen,Numfloat FROM dm_fielddict@linktest