oracleÔ¶³ÌÁ¬½Óµ¼Èëµ¼³öÊý¾Ý¿â

·½Ê½Ò».
Ö´ÐÐÒÔÏÂsqlÓï¾ä´´½¨database link
create database link test_link  --Á´½ÓÃû
  connect to   Óû§Ãû   identified by ÃÜÂë
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Êý¾Ý¿â·þÎñÆ÷µØÖ·)(PORT = ¶Ë¿Ú))   –-¶Ë¿ÚĬÈÏ1521
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ctaiscs)    --oracle9iÒÔºóÍƼöʹÓÃÈ«¾ÖÊý¾Ý¿âÃû
    )
  )'
SERVICE_NAME=ctais£¬¿ÉÒÔʹÓà SID = Êý¾Ý¿âSIDµÄ·½Ê½
Ok,ÏÖÔھͿÉÒÔ²éѯԶ³ÌÊý¾Ý¿â£»
Select *  from  employee@test_link
·½Ê½¶þ
a)ÅäÖ÷þÎñÃüÃû
´ò¿ªC:\Oracle\ora92\network\admin\ tnsnames.ora,Ìí¼Ó·þÎñÃüÃû
·þÎñÃû =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.30.12)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = È«¾ÖÊý¾Ý¿âÃû)  --Ò²¿ÉÓÃSID=Êý¾Ý¿âSID
    )
 )
b)н¨Êý¾Ý¿âÁ¬½Ó
create database link test_link  --Á´½ÓÃû
  connect to   Óû§Ãû   identified by ÃÜÂë
  using '·þÎñÃû'
ÏÂÃæµÄ´¦Àí·½Ê½Ò»ÑùÁË
ÏÂÃæ¸øÒ»¸öÁ´½ÓÔ¶³ÌÊý¾Ý¿âµ¼ÈëÊý¾ÝµÄÀý×Ó
Create or replace procedure test_proc
IS
Begin
     for x  in (select * from dj_nsrxx@test_link)
     loop
          insert into  dj_nsrxx values  x;
     end loop;
     commit;
end test_proc
³É¹¦Àý×Ó£º
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
MAXIMO =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = wangjun)(PORT = 1521))
    (CONNECT_DATA =
   &nb