The oracle db for our application was recently upgraded from 10.2.0.4.0 - 64bi to 10.2.0.5.0 - 64bi.
We have a long running MV process (approx 30-35 hours) in our application. These MVS are referesed from within shell scripts.
After the upgradation, we have started recieving SNAPshot too old error after running the MV refresh. The job gets failed after throwing snapshot too old error.
The current setting of undo retention paramters is 432000 (which is 120 hours).
If we try to run the process during weekends the same executes without any error.
Can someone help me in identifying RCA of this issue? Or is it some bug in oracle.
this forum is handling migration issues from foreign databases to Oracle using SQL Developer Migration Workbench. You're having an issue with your Oracle database and MVIEWS. Please close this thread and post your issue again in the database forum: General Questions