Snapshot too old
- From: Bill Zakrzewski <bill@xxxxxxxxxxxx>
- To: "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Feb 2010 09:04:17 -0500
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:
