Error during MView Refresh ORA-12008 ORA-13236 (Doc ID 2945623.1)

Last updated on APRIL 28, 2023

Applies to:

Goal

 Getting below error while refreshing Mview 

"----------------------------------START OF ORAWETH.MV_ZIPCD_LIGHTSTRIKE_CNTS  ----------------------------------"
BEGIN DBMS_SNAPSHOT.REFRESH( LIST => 'ORAWETH.MV_ZIPCD_LIGHTSTRIKE_CNTS',PUSH_DEFERRED_RPC => TRUE,REFRESH_AFTER_ERRORS => FALSE,PURGE_OPTION => 1,PARALLELISM=> 16,ATOMIC_REFRESH => FALSE ,NESTED => FALSE); END;

*
ERROR at line 1:
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-29903: error in executing ODCIIndexFetch() routine
ORA-13236: internal error in R-tree processing: []
ORA-13236: internal error in R-tree processing: [Snapshot too old or Recursive
fetch error]
ORA-13236: internal error in R-tree processing: [Snapshot too old or Recursive
fetch error]
ORA-13234: failed to access R-tree-index table [MDRT Table LOB Read Failure]

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.