dblink创建的几种方式

方式一：

       -- Create database link
create public database link DMS198_LINK
  connect to DMS_BIZ
  using '10.86.86.198:1521/dms1';

 

 

 

方式二：

 

create public database link SRMLINK
  connect to SARM
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.86.86.85)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = SARM)
      (SERVER = DEDICATED)
    )
  )';

 

 

 

方式三

 

create public database link SRMLINK
  connect to SRMPE
  using 'tnsnames.ora';