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 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

The following symptoms have been attributed to this issue :-

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: [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
error.

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