Oracle跨库链接操作

drop database link orclAB;
create  shared database link orclAB
  connect to TargetUserName identified by "TargetUser密码"
  AUTHENTICATED BY TargetUserName IDENTIFIED BY  "TargetUser密码"
  using ' (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.*.*.*)(PORT = 1521))
    )
    (CONNECT_DATA =
     (SERVICE_NAME = TargetServiceName)
    )
  )';