
ORA-04030 (callheap,kkpamkP_kkpam kkpamLDInit) Error Inserting Into Subpartitioned Table
(Doc ID 1535567.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
Symptoms
- An INSERT statement containing a subquery fails with:
ORA-04030: out of process memory when trying to allocate 2040 bytes (callheap,kkpamkP_kkpam kkpamLDInit)
- The INSERT statement looks like:
INSERT INTO AW_CUSTOMER_PAYPAL_HIST ( PAYMENTMETHODID, CUSTOMERID, PAYPALEMAIL, PAYPALID, FIRSTNAME, LASTNAME, ADDRESS1, ADDRESS2, CITY, STATE, COUNTRY, ZIP, DTE, COUNTRY_CODE )
SELECT /*+ parallel(d, 4) */ D.PAYMENTMETHODID, D.CUSTOMERID, D.PAYPALEMAIL, D.PAYPALID, D.FIRSTNAME, D.LASTNAME, D.ADDRESS1, D.ADDRESS2, D.CITY, D.STATE, D.COUNTRY, D.ZIP, D.DTE, D.COUNTRY_CODE
FROM INT_AW_CUSTOMER_PAYPAL D WHERE D.DTE > :B3 AND D.DTE < :B2 AND D.AW_ID = :B1
Cause
|
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.