My Oracle Support Banner

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

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
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.