Data changes in snap shot can be triggered - Oracle Replication

Discussion

• Nirja Shah   -Posted on 18 Sep 15
  - A snapshot contains on the remote site the data of the master table.
  
  - All data changes are reflected in the snapshot after a refresh of the snapshot (either triggered manually or automatically).
  
  - Example
  CREATE SNAPSHOT emp
  PCTFREE 15
  STORAGE
  (INITIAL 200K
  NEXT 200K
  PCTINCREASE 0)
  TABLESPACE tab
  USING INDEX
  PCTFREE 0
  STORAGE
  (INITIAL 200K
  NEXT 200K
  PCTINCREASE 0)
  TABLESPACE idx
  REFRESH FORCE
  START WITH SYSDATE NEXT SYSDATE+(1/1440) /* 60 SECONDS */
  AS SELECT * FROM emp@QUO3;

➨ Post your comment / Share knowledge