Re: Snapshot too old

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: