<div>
I don't think I can really help, but the experts who can probably will want to know what the error message is<br />
<br />
mlmcc
</div>


I don't think I can really help, but the experts who can probably will want to know what the error message is

mlmcc

<div>
Hi,<br />
You can use dbms_mview.explain_mview to know the reason that prevent fast refresh.<br />
But if the base table is remote on MSSQL &nbsp;you can't do fast refresh.<br />
Regards,<br />
Franck.
</div>


Hi,
You can use dbms_mview.explain_mview to know the reason that prevent fast refresh.
But if the base table is remote on MSSQL  you can't do fast refresh.
Regards,
Franck.

<div>
&gt;&gt; &quot;But if the base table is remote on MSSQL &nbsp;you can't do fast refresh.&quot; <br />
<br />
yes, the remote table is remote on MSSQL, are you absolutely sure?
</div>


>> "But if the base table is remote on MSSQL  you can't do fast refresh."

yes, the remote table is remote on MSSQL, are you absolutely sure?

<div>
<div class="content wysiwyg-content">
Can someone please give me the correct steps to getting a materialized view to do a fast refresh. <br />
<br />
I added primary keys to the table and create the MV log, but I still get an error when trying to &nbsp;do a fast refresh, i have to do a complete refresh each time, and this table is about 8 gigs on a remote MSSQL server.<br />
<br />
Any hellp would be appreciated. Thanks
</div>
</div>


Can someone please give me the correct steps to getting a materialized view to do a fast refresh. 

I added primary keys to the table and create the MV log, but I still get an error when trying to  do a fast refresh, i have to do a complete refresh each time, and this table is about 8 gigs on a remote MSSQL server.

Any hellp would be appreciated. Thanks

Materialized view, logs, and fast refresh.

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.