I think the 'ora-02063 line preceding message from' line means its from the remote db. On Tue, Feb 16, 2010 at 8:15 AM, Bradd Piontek <piontekdd@xxxxxxxxx> wrote: > Bill, > That is almost certainly on the master site. One big indicator is the > blank Undo segment name. Another way to verify is to check the alert log. > ORA-1555 errors are typically logged there as well. > > > Bradd Piontek > Pythian - Love Your Data > > > > On Tue, Feb 16, 2010 at 8:04 AM, Bill Zakrzewski <bill@xxxxxxxxxxxx>wrote: > >> All - >> >> I am refreshing a materialized view and occasionally receive the below >> error. Should I be looking at the local database rollback segment or the >> remote databases rollback segment? As I don't believe anything is running >> locally it must be on the remote database, but wanted to verify before I >> start trying to tune/fix the issue in the wrong database. >> >> >> ORA-12012: error on auto execute of job 42 >> >> ORA-12008: error in materialized view refresh path >> >> ORA-01555: snapshot too old: rollback segment number with name "" too >> small >> >> ORA-02063: preceding line from FEMA_ODS >> >> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251 >> >> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457 >> >> ORA-06512: at "SYS.DBMS_IREFRESH", line 685 >> >> ORA-06512: at "SYS.DBMS_REFRESH", line 195 >> >> ORA-06512: at line 1 >> >> >> Thanks >> Bill >> > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'