Oracle Distributed Processing Interview Questions and Answers

 

What are the options available to refresh Oracle snapshots?

COMPLETE - Tables are completely regenerated using the snapshots 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.

Posted by:Richards