Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

Oracle Materialized View

Hi,

Can you please let me know what will happen if I query a oracle materialized view during materialized view refresh?

Thanks.
0
GouthamAnand
Asked:
GouthamAnand
  • 2
1 Solution
 
johnsoneSenior Oracle DBACommented:
Fast refresh or complete refresh?

During a complete refresh you should see no rows in the view.  A complete does a truncate and load.  Once complete the load is committed and you will see all data.

During a fast refresh you should see the pre-refresh data.  It is transactional and committed at the end.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I confirm above.
which is the reason why, on my MV which are complete refresh, I have 2 of them, and a view that is directed to the "other" one I am refreshing, and the applications use the view, not the MV .
0
 
johnsoneSenior Oracle DBACommented:
We did it with 2 mviews and a synonym.  Everything used the synonym and didn't know the name of the mview.  Once the refresh completed successfully, the synonym was changed.
0
 
GouthamAnandAuthor Commented:
Thank you.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now