My Oracle Support Banner

ORA-7445 kkpamIsPKeyFKeyJoin()/kkpamIsRefKeyFKeyJoin() (Doc ID 2434443.1)

Last updated on MARCH 10, 2020

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

 Select fails with ORA-7445 kkpamIsPKeyFKeyJoin()/kkpamIsRefKeyFKeyJoin()

STACK:

STACK: Ksedst dbkedDefDump ksedmp ssexhd sslssSynchHdlr sslsshandler sighandler kkpamIsPKeyFKeyJoin
kkpamCheckTransJoin kkoPWJfull kkojnp kkocnp kkooqb kkoqbc apakkoqb apaqbdDescendents apaqbd apadrv
opitca kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx kpoal8 opiodr
ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain

Also, if partition-wise join for ref partitioned tables
is not working when index on the parent key in non-unique or has
columns in addition to the parent key columns, then this could be the candidate bug.

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
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.