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: 11.2.0.1 to 11.2.0.2.0 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms

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 ...


Changes

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

Cause

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