What is a SNAPSHOT LOG? Options to refresh snapshots in oracle.

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.
What is difference between open_form and call_form?
Open_form opens the indicated form. Call_form not just opens the indicated form, but also keeps the parent form alive.....
Difference between post database commit and post-form commit
Post-form commit fires once during the post and commit transactions process, after the database commit occurs......
What is advantage of having disk shadowing/ Mirroring in oracle?
Advantage of having disk shadowing/Mirroring....
Post your comment