Error in materialized view or zonemap refresh path ORA-06512
Hi All,
We are experiencing Zone map error in our MV refresh process, and it happens pretty often, and the process goes to Success upon restart of the process. The error also says Object no longer exists. We are working with our DBA team, but so far, no solution.
It looks like the delivered MV process uses the internal function "SamRefreshView (&MatRecords.RECNAME.Value)" to refresh the MV's.
Any input is appreciated to fix this happening is appreciated.
-------------
The Process: PTMATREFVW (#2001608) failed to complete successfully
File: /vob/peopletools/src/pssam/samutil.cppSQL error. Stmt #: 9657 Error Position: 0 Return: 12008 - ORA-12008: error in materialized view or zonemap refresh path ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3020 ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2432 ORA-08103: object no longer exists ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 88 ORA