Snapshots and SNAPSHOT LOGs
Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table.
A snapshot log is a table in the master database that is associated with the master table. ORACLE uses a snapshot log to track the rows that have been updated
Snapshot is an object used to dynamically replicate data between distribute database at specified time intervals. In ver 7.0 they are read only.
- A simple snapshot is based on a query that does not contains GROUP BY clauses, CONNECT BY clauses, JOINs, sub-query or snashot of operations.
COMPLETE - Tables are completely regenerated using the snapshots query and the master tables every time the snapshot referenced.FAST - If simple snapshot
It is a table that maintains a record of modifications to the master table in a snapshot. It is stored in the same database as master table and is only available
We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges. We cannot specify snapshot log name because oracle uses
