ORA-04030 When Rows Inserted In A Table With A Text Index (Doc ID 2344526.1)

Last updated on APRIL 07, 2022

Applies to:

Symptoms

When attempting to insert rows into a table that has an Oracle Text index, an ora-4030 error is raised.

insert into <owner>.<table> df select * from <owner>.<table> df2 where rownum < 10000 and df2.file_id
not in (select df3.file_id from ipms_datafiles df3 )

ERROR at line 1:
ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-04030: out of process memory when trying to allocate 65560 bytes (CTX PRM
heap,draccbx:message buffer)
ORA-06512: at "CTXSYS.DRUE", line 191
ORA-06512: at "CTXSYS.DRUE", line 49
ORA-06512: at "CTXSYS.DRUE", line 24
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 751
ORA-04030: out of process memory when trying to allocate 65560 bytes
(droinst:prm he,drugiik:enc buffer)

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.