MATERIALIZED VIEW REFRESHES FAIL WITH ORA-00600[16671], [kqldic], [U], [0], [XXXXX] (Doc ID 1292920.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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


The following symptoms have been attributed to this issue :-

a) Materialized view refresh fails similar to the following

SQL> execute DBMS_SNAPSHOT.REFRESH( '<Name>','?');

ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [16671], [kqldic], [U], [0],[267098], [], [], []
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[16671] 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


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