My Oracle Support Banner

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

Last updated on APRIL 07, 2022

Applies to:

Oracle Text - Version 11.2.0.4 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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