What are the options available to refresh Oracle snapshots?
Submitted by: AdministratorCOMPLETE - 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Distributed Processing Job Interview Questions And Answers
Top Distributed Processing Questions
☺ | How can you Enforce Referential Integrity in oracle snapshots? |
☺ | What is Oracle Distributed database? |
☺ | When will the data in the oracle snapshot log be used? |
☺ | What is an oracle SNAPSHOT? |
☺ | What are the options available to refresh Oracle snapshots? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |