snapshot

-- Create database link 

create database link DBLINK_HK.US.ORACLE.COM

  connect to TK_DOCMANAGER identified by PASSWORD

  using '(DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.3.245)(PORT = 1521))

    )

    (CONNECT_DATA =

      (sid = kmhk)

    )

    )';

 

create snapshot log on tablename with rowid;

 

create snapshot sn_tablename refresh complete with rowid start with sysdate+5/24*60*60 next sysdate+5/24*60*60 

as select * from tablename@dblink_hk;--5s refresh