Data changes in snap shot can be triggered - Oracle Replication

Q.  Data changes in a snap shot can be triggered ________.
- Published on 13 Aug 15

a. Manually
b. Automatically
c. Both a and b
d. Scheduled

ANSWER: Both a and b
 

    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


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)