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

Last updated on FEBRUARY 22, 2019

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 <TABLE_NAME> ( <COLUMN_NAME1>, <COLUMN_NAME2>, <COLUMN_NAME3>, <COLUMN_NAME4>, <COLUMN_NAME5>, <COLUMN_NAME6>, <COLUMN_NAME7>, <COLUMN_NAME8>, <COLUMN_NAME9>, <COLUMN_NAME10>, <COLUMN_NAME11>, <COLUMN_NAME12>, <COLUMN_NAME13>, <COLUMN_NAME14> )
   SELECT /*+ parallel(d, 4) */ D.<COLUMN_NAME1>, D.<COLUMN_NAME2>, D.<COLUMN_NAME3>, D.<COLUMN_NAME4>, D.<COLUMN_NAME5>, D.<COLUMN_NAME6>, D.<COLUMN_NAME7>, D.<COLUMN_NAME8>, D.<COLUMN_NAME9>, D.<COLUMN_NAME10>, D.<COLUMN_NAME11>, D.<COLUMN_NAME12>, D.<COLUMN_NAME13>, D.<COLUMN_NAME14>
   FROM INT_AW_CUSTOMER_PAYPAL D WHERE D.<COLUMN_NAME13> > :B3 AND D.<COLUMN_NAME13> < :B2 AND D.<COLUMN_NAME15> = :B1

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.