Re: Snapshot too old
- From: Bill Zakrzewski <bill@xxxxxxxxxxxx>
- To: piontekdd@xxxxxxxxx
- 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:
> 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
>
Other related posts:
