My Oracle Support Banner

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

Last updated on MARCH 10, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


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, "XYZ") dbms_stats
cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring
no_substrb_pad no_expand index(t,"XYZ") */ 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
"ABCD"."XXXX" t where ("PROC_SEQ" is not null) and
OC_SEQ") = :objn)

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




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.