Snapshot too old
From: Bill Zakrzewski <bill_at_intactus.com>
Date: Tue, 16 Feb 2010 09:04:17 -0500
Message-Id: <CFF1C876-8246-4EAD-A150-E284A01014FB_at_intactus.com>
All -
Date: Tue, 16 Feb 2010 09:04:17 -0500
Message-Id: <CFF1C876-8246-4EAD-A150-E284A01014FB_at_intactus.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 16 2010 - 08:04:17 CST