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: 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 ...
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|