My Oracle Support Banner

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

Last updated on APRIL 06, 2020

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


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

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