创建database link

-- Create database link 
--username, password, host and service_name should be replaced with real values on line;

create public database link DBLINK_D
  connect to DFJR_NEW_3F_D identified by CZTY_DFJR_NEW_3F_D
  using '(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.150.233)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZSMS)
    )
)';