Materialized view refresh failure ORA-7445 kkzg_local_idx_DDLs/ORA-600 [12811] (Doc ID 1532224.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Refresh of Materialized view can fail with any of these errors:

SQL> execute dbms_mview.refresh('GEX5.X5ESB4MV','F',ATOMIC_REFRESH => FALSE);

BEGIN dbms_mview.refresh('GEX5.X5ESB4MV','F',ATOMIC_REFRESH => FALSE); END;

*
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-600: internal error code, arguments: [12811]
ORA-6512: at "SYS.DBMS_SNAPSHOT", line 2563

OR the following error message could be encountered

ora-7445 [kkzg_local_idx_DDLs()+970] instead of the ora-600 [12811] for the
same failing current sql .

----- Current SQL Statement for this session (sql_id=3z74f9rm5a4n1) -----
SELECT "X5ESBAFS"."NB_TKSRC2_366SRC2"
"NB_TKSRC2_366SRC2","X5ESBAFS"."CO_BOOK_366BOOK"
"CO_BOOK_366BOOK","X5ESBAFS"."CO_CADI_366CADI" "CO_CADI_366CADI",CASE
WHEN ("X5ESBAFS"."ST_ORPHAN_298ESBA"='1' AND
"X5ESBAFS"."CO_LDBF_366LDBF"<>'9999' AND "X5ESBAFS"."ST_TSTABLE_298ESBA"='0'
AND "X5ESBAFS"."CO_FEES_298ESBA"<>
------------------
------------------
CYECO_366CMPY","X5ESBAFS"."CO_LDBF_366LDBF","X5ESBAFS"."ST_TSTABLE_298ESBA","
X5ESBAFS"."CO_BL1BL2_298ESBA"
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
700000040b61d10 84 package body SYS.DBMS_SNAPSHOT
700000040b61d10 1833 package body SYS.DBMS_SNAPSHOT

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms