What are the options available to refresh snapshots ?
Answers were Sorted based on User's Feedback
Answer / guest
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 ? | 2 Yes | 0 No |
Answer / 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 |
what is the step for rmanbackup?
what is different between view and sequence?
What are the system resources that can be controlled through Profile ?
How can you enable automatic archiving ?
What is user Account in Oracle database ?
How can you Enforce Refrencial Integrity in snapshots ?
How can we specify the Archived log file name format and destination ?
What are the various type of snapshots ?
How will you enforce security using stored procedures ?
How can we reduce the network traffic ?
What is Tablespace Quota ?
What are the options available to refresh snapshots ?