Re: Snapshot too old

From: David Fitzjarrell <>
Date: Tue, 16 Feb 2010 06:16:28 -0800 (PST)
Message-ID: <>

The message comes from the remote database; I would start looking there.
David Fitzjarrell

From: Bill Zakrzewski <>
To: "" <>
Sent: Tue, February 16, 2010 9:04:17 AM
Subject: Snapshot too old

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



Received on Tue Feb 16 2010 - 08:16:28 CST

Original text of this message