Oracle Distributed Processing Question:
Download Job Interview Questions and Answers PDF
What are the options available to refresh Oracle snapshots?
Answer:
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.
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.
Download Distributed Processing Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What are the various type of snapshots in Oracle? | When will the data in the oracle snapshot log be used? |