error encountered while refreshing materialized view [message #249302] |
Wed, 04 July 2007 00:50 |
kamragulshan
Messages: 66 Registered: May 2005 Location: Delhi
|
Member |
|
|
I have oracle 10.2.0.2 on solaris 5.9. I got the below errors in alert.log file:
ORA-12012: error on auto execute of job 436955
ORA-12048: error encountered while refreshing materialized view "GPS_MM_LDC_FRAME"."MV_TRACK_2D_EX"
ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2$" too small
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Please help me solve this error.
Thanks
gulshan
|
|
|
|
|
Re: error encountered while refreshing materialized view [message #249748 is a reply to message #249370] |
Thu, 05 July 2007 14:27 |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
Quote: | ORA-01555: snapshot too old: rollback segment number string with name "string" too small
Cause: rollback records needed by a reader for consistent read are overwritten by other writers
Action: If in Automatic Undo Management mode, increase undo_retention setting. Otherwise, use larger rollback segments
|
|
|
|
|