Orale 错误：ORA-02019 connection description for remote database not found（检查及创建DBLINK）

   不知道为啥DBLNK 被人删了在执行procedure的时候报上述错误。     

   select owner,object_name

from dba_objects where object_type='DATABASE LINK'

;   检查DBLNK

 create   database link DBLINKNAME   创建DBLNK
      connect to "USERNAME"
      identified by "PASSWORD"
      using '(DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=)
      (PORT=)
    )
    (CONNECT_DATA=
      (SERVER=dedicated)
      (SERVICE_NAME=)
    ))';