Re: Snapshot too old

From: Bill Zakrzewski <bill_at_intactus.com>
Date: Tue, 16 Feb 2010 09:35:11 -0500
Message-Id: <B9138590-96ED-4641-ADCB-EE6DD3CCF10A_at_intactus.com>

Thanks to all for the quick answers!!

On Feb 16, 2010, at 9:15 AM, Bradd Piontek 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_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
>
>
> Thanks
> Bill
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 16 2010 - 08:35:11 CST