<div>
<div class="content wysiwyg-content">
Hello Experts, <br />
<br />
I was doing my normal routine when it comes to updating my materialized views from the Oracle console; however, when I did it for a few with the same &quot;Master Link&quot; I get:<br />
<br />
ORA-12008: error in materialized view refresh path ORA-04052: error occurred when looking up remote object MATHEWJ.CATEGORIES@FRESH.U<wbr />S.ORACLE.C<wbr />OM ORA-00604: error occurred at recursive SQL level 2 ORA-12537: TNS:connection closed ORA-06512: at &quot;SYS.DBMS_SNAPSHOT&quot;, line 2254 ORA-06512: at &quot;SYS.DBMS_SNAPSHOT&quot;, line 2460 ORA-06512: at &quot;SYS.DBMS_SNAPSHOT&quot;, line 2429 ORA-06512: at line 1<br />
<br />
I am not proficent in Oracle so I am kind of clueless when it comes to things like this, so how should I go about troubleshooting this.<br />
<br />
Thanks in advance.
</div>
</div>


Hello Experts, 

I was doing my normal routine when it comes to updating my materialized views from the Oracle console; however, when I did it for a few with the same "Master Link" I get:

ORA-12008: error in materialized view refresh path ORA-04052: error occurred when looking up remote object MATHEWJ.CATEGORIES@FRESH.US.ORACLE.COM ORA-00604: error occurred at recursive SQL level 2 ORA-12537: TNS:connection closed ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2429 ORA-06512: at line 1

I am not proficent in Oracle so I am kind of clueless when it comes to things like this, so how should I go about troubleshooting this.

Thanks in advance.

Error When Refreshing Materialized Views

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.