Re: Snapshot too old
Date: Tue, 16 Feb 2010 09:35:11 -0500
Thanks to all for the quick answers!!
On Feb 16, 2010, at 9:15 AM, Bradd Piontek wrote:
> 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_at_intactus.com> 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