MATERIALIZED VIEW REFRESHES FAIL WITH ORA-00600, [kqldic], [U], , [XXXXX]
(Doc ID 1292920.1)
Last updated on APRIL 06, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
a) Materialized view refresh fails similar to the following
SQL> execute DBMS_SNAPSHOT.REFRESH( '<Name>','?');
BEGIN DBMS_SNAPSHOT.REFRESH( '<Name>','?'); END;
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: , [kqldic], [U], ,, , , 
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426
ORA-06512: at line 1
The 4th argument of the 600 error represents the objectid of the problem object,
in this case 267098
The object might be identifiable as a recyclebin object via :-
SELECT * FROM obj$ as of timestamp (sysdate - 1/2) where obj# = 267098;
Whilst the note is based on a service request showing problems with a materialized view
it was also observed in the service request that a CTAS of the base table also raised the
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document