• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 513
  • Last Modified:

Oracle Materialized View


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

  • 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.
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 .
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.
GouthamAnandAuthor Commented:
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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