Advanced replication facility allows applications to insert, update & delete table rows

Q.  Advanced replication facility allows applications to insert, update, and delete table rows through updatable snapshots.
- Published on 12 Aug 15

a. True
b. False

ANSWER: True

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 18 Sep 15
    - Master sites in an advanced replication system can consolidate the information that applications update at remote snapshot sites.

    - Oracle's symmetric replication facility allows applications to insert, update, and delete table rows through updatable snapshots.

    - Updatable snapshots have the following properties.
    1. Updatable snapshots are always simple, fast-refreshable table snapshots.

    2. Oracle propagates the changes made through an updatable snapshot to the snapshot's remote master table. If necessary, the updates then cascade to all other master sites.

    3. Oracle refreshes an updatable snapshot as part of a refresh group, identical to read-only snapshots.

    4. Updatable snapshots have the same underlying objects (base table, indexes, and views) as read-only snapshots. Additionally, Oracle creates a table USLOG$_snapshotname to support updatable snapshots.

➨ 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.)
▲