Answers

Question and Answer:

  Home  Oracle Security

⟩ Explain What are the options available to refresh snapshots?

COMPLETE - Tables are completly regenerated using

the snapshot's query and the master tables every time the

snapshot referenced.

FAST - If simple snapshot used then a snapshot log can be

used to send the changes to the snapshot tables.

FORCE - Default value. If possible it performs a FAST

refresh; Otherwise it will perform a complete refresh.

 189 views

More Questions for you: