ORA-600 [qkaIsLoadMatched_1] On Insert to Partitioned Table

(Doc ID 1530158.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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


create table prob1
partition by range (SZINT)
subpartition by list (ADOALANY_PARTICIO_KOD)
subpartition template (subpartition s0 values ('0'),
  subpartition s1 values ('1') ,
  subpartition s2 values ('2') ,
  subpartition D values (DEFAULT))
  partition P_SZ_1 values less than ('2'),
  partition P_SZ_2 values less than ('3'),
  partition P_SZ_MAX values less than (MAXVALUE)

explain plan for
insert /*+ append parallel (x)*/ into prob1 x (SZINT)
select (SZINT) from prob1 t
 where 6 = 7;

gets: ORA-00600: internal error code, arguments: [qkaIsLoadMatched_1], [1], [1], [1], [], [], [], [], [], [], [], []


The Call Stack trace in the trace file written by the error includes all or some of the following functions:

qkalsLoadMatched <- qkalsLoadEquiPartitioned <- qkaidlSetup <- qkainsdl <- qkainsert ....

Note that the insert is not loading into all the partitioning columns.


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