I have a snap shot which is auto refreshed on the last day of each month.The refresh is a complete refresh .The master table (i.e the source table) resides in anather database and we use a dblink to transfer data .This month end the resfresh process failed and the error found in the alert log is as follows...
Tue Mar 2 09:06:52 2004
Errors in file /nad/u01/app/oracle/admin/nadlive/bdump/nadlive_j000_19725.trc:
ORA-12012: error on auto execute of job 9
ORA-12008: error in materialized view refresh path
ORA-04052: error occurred when looking up remote object SEAM.V_NAD_EXCHANGE_POSTCODE@SEAM.ODM
ORA-00604: error occurred at recursive SQL level 3
ORA-02085: database link SEAM.ODM connects to SEAM
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Can any body help me out with this problem ?
Thanks in advance
Sorry for responding late. You were right it was a global_names problem.The production Dba had changed this parameter to "false" dynamically when the code went into production but he forgot to change it in init.ora file where it was "true". I checked the server uptime which suggested that it was bounced in the last few days so all the dynamic change was lost with the database picking up the physical value out of the init.ora.This resulted in the failure of the Snapshot refresh process .