On 30/10/2013 00:11, Radoulov, Dimitre wrote: > On 30/10/2013 00:01, Radoulov, Dimitre wrote: >> On 29/10/2013 23:25, Paul Drake wrote: >>> >>> Try "1" for sqlnet expire time. Other values are known not to work. [...] > I suppose they run a cold backup or some other maintenance task now > ... :) > I hope that Phil (firewall timeout) and Paul (expire_time = 1) are right, > there could be another, somehow more "aggressive" firewall on the > remote side. > > I'll try again tomorrow and let you know. Hi, rerun the refresh again, sqlnet expire time 1 doesn't seem to help: ERROR at line 1: ORA-12008: error in materialized view refresh path ORA-12592: TNS:bad packet ORA-02063: preceding line from <edit> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426 ORA-06512: at line 2 Elapsed: 00:04:34.88 Thanks Dimitre -- //www.freelists.org/webpage/oracle-l