<div>
I confirm above.<br />
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 &quot;other&quot; one I am refreshing, and the applications use the view, not the MV .
</div>


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 .

<div>
We did it with 2 mviews and a synonym. &nbsp;Everything used the synonym and didn't know the name of the mview. &nbsp;Once the refresh completed successfully, the synonym was changed.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Can you please let me know what will happen if I query a oracle materialized view during materialized view refresh? <br />
<br />
Thanks.
</div>
</div>


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

Oracle Materialized View

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.