My Oracle Support Banner

ORA-04036 or ORA-04030 During Text Index Creation or Rebuild (Doc ID 2675828.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

ALTER INDEX REBUILD Fails Terminates With ORA-4030 (drecinit,drecgchk:newpg):

----- Error Stack Dump -----
ORA-04030: out of process memory when trying to allocate 9104 bytes (diag pga,adl context curMsg)
ORA-04030: out of process memory when trying to allocate 20032 bytes (drecinit,drecgchk:newpg)
----- Current SQL Statement for this session (sql_id=d0a3fwy5gxpjs) -----
ALTER INDEX ctxtest.mytestidx REBUILD


Or manually creating the index terminates with an ORA-4036:



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.