Unanswered: Problem with automatic refresh of Snapshots
Iīm experimenting problems with some of the snapshots that i migrate from Oracle 8 to 9.2.
I get this error message in some of the MV on the automatic refresh.
ORA-12012: error on auto execute of job 191
ORA-04045: errors during recompilation/revalidation of
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
When I try to refresh it manually there is no problem a all....