dblink创建语句模板

create public database link db1

  connect to user identified by ***** using

'(DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = **IP**)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = servicename)

    )   )' ;