ORA-600 KKPAPDAFKKSLV: REF FKKCID on Referenced Partitioned Table (Doc ID 1374323.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

SQL statements on reference partitioned table may fail with ORA-600 kkpapDAFkkSlvl: ref fkkcid

----- Current SQL Statement for this session

select /*+ no_parallel_index(t, "MDS_PROUT_UK") dbms_stats
cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring
no_substrb_pad no_expand index(t,"MDS_PROUT_UK") */ count(*) as
nrw,count(distinct sys_op_lbid(12205412,'L',t.rowid)) as nlb,null as
ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from
"GNSUPER"."MDS_PROCEDURE_REQUEST_OUTPUT" t where ("PROC_SEQ" is not null) and
(TBL$OR$IDX$PART$NUM("GNSUPER"."MDS_PROCEDURE_REQUEST_OUTPUT",12205412,4,0,"PR
OC_SEQ") = :objn)

0x21179e8c0 13761 package body SYS.DBMS_STATS
0x21179e8c0 14440 package body SYS.DBMS_STATS


CALL STACK:

 
 

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