Re: Snapshot too old

From: Harel Safra <>
Date: Tue, 16 Feb 2010 19:11:20 +0200
Message-ID: <599000892301558574_at_unknownmsgid>

As evidenced by:

ORA-02063: preceding line from FEMA_ODS

The error is from the remote database.

Harel Safra

ב-16/02/2010, בשעה 16:04, Bill Zakrzewski <> כתב/ה:

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


Received on Tue Feb 16 2010 - 11:11:20 CST

Original text of this message