Merge In 11.2 Containing Multiple Nested UNION Statements Generates An ORA-4030 Error

(Doc ID 1202314.1)

Last updated on SEPTEMBER 09, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 11.2 to 11.2
Information in this document applies to any platform.


ORA-4030 errors occurring after upgrade to 11.2 from 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 ...


The database has been upgraded to 11.2 or a new MERGE statement written.


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