• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • 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
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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