Posted By

mifly on 02/24/10


Tagged

Oracle


Versions (?)

create dblink


 / Published in: SQL
 

  1. CREATE public DATABASE link dblink_name
  2. connect TO CRMTEST IDENTIFIED BY crmtest
  3. USING '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
  4. (HOST=135.*.*.*)(PORT=1521)))
  5. (CONNECT_DATA=(SERVICE_NAME=xxx))
  6. )';

Report this snippet  

You need to login to post a comment.