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 188.8.131.52 and later
Information in this document applies to any platform.
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
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)
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