ORA-00600 [kqlchg-parent-not-pinned] Error When Using a Package Function Referenced in an Index of a View Used in a Materialized View
Last updated on OCTOBER 12, 2015
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
An ORA-00600 [kqlchg-parent-not-pinned] error is raised after upgrade to 126.96.36.199 when using a package function in an index defined on a table used in a view referenced in a materialized view.
The call stack will resemble the following:
Refreshing the materialized view can temporarily workaround the error.
Database was upgraded to 188.8.131.52.
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