1. Categories >> Software >> Databases >> Oracle >> Oracle Security
  2. Suggest New Category

What are the options available to refresh snapshots ?

Question Posted / nishi

Answer Posted / nishi

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.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category