Merge In 11.2 Containing Multiple Nested UNION Statements Generates An ORA-4030 Error
Last updated on SEPTEMBER 09, 2010
Applies to:Oracle Server - Enterprise Edition - Version: 126.96.36.199 to 188.8.131.52.0 - Release: 11.2 to 11.2
Information in this document applies to any platform.
ORA-4030 errors occurring after upgrade to 11.2 from 10.2.0.4 on executing complex MERGE statements which contain a large number of nested UNION (or other set function) statements. The call stack will show multiple calls to module qksqbApplyToQbc() from module kkqtutlCleanupSubqCB(), e.g.:
kghnospc kghalf kghssgai kghsskinit qcopitinit kkqtutlMarkRefsInQBqksqbApplyToQbcLoc ... qksqbApplyToQbcLoc kkqtutlCleanupSubqCB ...
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms