Dblink 实现数据库表同步



--查看所有的dblink;
        select * from dba_db_links;

--新建dblink   （public为所有的用户使用，不写public则只是用户自己使用）

 create public database link oatooa
   connect to USERNAME identified by PASSWORD
   using '(DESCRIPTION =  
      (ADDRESS_LIST =  
      (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.111)(PORT = 1521))  
      )  
      (CONNECT_DATA =  
        (SERVICE_NAME = orcl)  
      )  
  )';
  

--删除dblink

      drop  database link oatooa;

      drop  public  database link oatooa;

--实现表更新快照

   Create snapshot  table_PACT
   REFRESH COMPLETE START WITH SYSDATE NEXT sysdate+1
   as select * from PACT@oatooa

    select *  from  all_snapshots;

   ALTER SNAPSHOT PACT REFRESH COMPLETE START WITH SYSDATE NEXT SYSDATE+1/2;