Query on List-partitioned Table Fails With ORA 600 [kkpapXformFkk2Key_1] -- Fixed by Bug 20846438 Although Bug Rediscovery Different (Doc ID 2080115.1)

Last updated on NOVEMBER 19, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

A query failed with ORA 600 [kkpapXformFkk2Key_1].  The query involved a list-partitioned table and the logical equivalent of a NOT IN clause; the plan was serial.  The explain plan showed the following:

Changes

 Upgrade to 12.1.0.2.

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