ORA-04030 (callheap,kkpamkP_kkpam kkpamLDInit) Error Inserting Into Subpartitioned Table

Last updated on NOVEMBER 28, 2016

Applies to:

Symptoms

1. An INSERT statement containing a subquery fails with:
   
   ORA-04030: out of process memory when trying to allocate 2040 bytes (callheap,kkpamkP_kkpam kkpamLDInit)
2. 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