What is a SNAPSHOT LOG? What are the options available to refresh snapshots in oracle?A snapshot log is a copy of the master table. The snapshot table is updated using batch updates.
The log can also be used to track the rows that have been updated in the master table.
Sanpshots can be updated using the following types:
COMPLETE - Tables are completely regenerated using the snapshots query and the master tables every time the snapshot referenced.
FAST - Here, the most recent changes made to the master table are applied to the snapshot.
FORCE - Default value. It first tries a FAST refresh; if failed will perform a complete refresh.