Oracle DB Link

Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£
  
1¡¢ ÅäÖÃTNS £¬ $ORACLE_HOME/NETWORK/ADMIN/tnsname.ora
10gstandby =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = HFCC-KF-3068)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = 10gstandby)
    )
  )
  
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
create public database link DB_LINK_NAME connect to TargetDatabaseUserName identified by TargetDatabasePassword using 'TargetDatabaseSIDName';
×¢£ºTargetDatabaseSIDNameΪ¸ÃOracleÊý¾Ý¿âËùÔÚµÄÖ÷»úÉϵÄtnsnames.oraÎļþÀï±ß¶¨ÒåµÄÊý¾Ý¿âÁ¬½Ó´®¡£
  
SQL>create public database link dvd connect to system identified by system using 'orcl10g';
  
Ôò´´½¨ÁËÒ»¸öÒÔsystemÓû§ºÍorcl10gÊý¾Ý¿âµÄÁ´½Ódvd£¬ÎÒÃDzéѯdvdÊý¾Ý:
  
SQL>select * from all_users@dvd;  
  
ÕâÑù¾Í¿ÉÒ԰ѱ¾µØºÍÔ¶³ÌµÄÊý¾Ý×ö³ÉÒ»¸öÕûÌåÀ´´¦Àí¡£
  
3¡¢½¨Á¢Í¬Òå´Ê£¬ÎªÁËʹÓйطֲ¼Ê½²Ù×÷¸ü͸Ã÷£¬ORACLEÊý¾Ý¿âÀïÓÐͬÒå´ÊµÄ¶ÔÏósynonym
  
SQL>create synonym synTest for all_users@dvd;
  
ÓÚÊǾͿÉÒÔÓÃsynTestÀ´Ìæ´ú´ø@·ûºÅµÄ·Ö²¼Ê½Á´½Ó²Ù×÷all_users@dvd;
  
4¡¢²é¿´ËùÓеÄÊý¾Ý¿âÁ´½Ó£º
  
SQL>select owner,object_name from dba_objects where object_type='DATABASE LINK';
5¡¢²é¿´Êý¾Ý¿âÁ¬½Ó
sql> select owner, db_link from dba_db_links;
ower    db_link
public   DVD.REGRESS.RDBMS.DEV.US.ORACLE.COM
6¡¢É¾³ýÊý¾Ý¿âÁ¬½Ó
ÏÈ´ÓµÚ5²½Öв鿴Êý¾Ý¿âÁ¬½Ó£¬È¡µÃÆädb_linkµÄÃû³Æ
sql>drop public database link DVD.REGRESS.RDBMS.DEV.US.ORACLE.COM
Êý¾Ý¿âÁ¬½ÓËȶªÆú