Hi..

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
SFEUSER.V_MKTG_PRODUCCION
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....

Thanks in advance
H. Romero