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

(Doc ID 1535567.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

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

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