Home » Server Options » Replication » error encountered while refreshing materialized view
error encountered while refreshing materialized view [message #249302] Wed, 04 July 2007 00:50 Go to next message
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 #249331 is a reply to message #249302] Wed, 04 July 2007 02:10 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

kamragulshan wrote on Wed, 04 July 2007 11:50

ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2$"
gulshan



Rollback Segment "_SYSSMU2$"
Re: error encountered while refreshing materialized view [message #249370 is a reply to message #249302] Wed, 04 July 2007 03:38 Go to previous messageGo to next message
jawi
Messages: 3
Registered: July 2007
Junior Member
Hi kamragulshan

The problem is with your "Rollback Segments", they are too small or too few and not with the materialized view.

James
Re: error encountered while refreshing materialized view [message #249748 is a reply to message #249370] Thu, 05 July 2007 14:27 Go to previous messageGo to next message
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
Re: error encountered while refreshing materialized view [message #254226 is a reply to message #249302] Thu, 26 July 2007 03:48 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Increase undo_retention parameter.

Regards
Michel
Previous Topic: Foreign Keys in Replication
Next Topic: replication script ERROR .. help me urgent .. script attached..
Goto Forum:
  


Current Time: Fri Mar 29 09:40:45 CDT 2024