ORA-04030, create text index error

From: lsllcm <lsllcm_at_gmail.com>
Date: Sat, 7 Mar 2009 18:30:04 -0800 (PST)
Message-ID: <9c4e0293-1e16-46bb-b94e-2376e102d581_at_o11g2000yql.googlegroups.com>



ORA-04030, create text index error

SQL> create index t1_idx on t1(IS_ACCESS_BY)   2 indextype is ctxsys.context
  3 parameters( 'datastore foo_user_datastore lexer my_lexer');

create index t1_idx on t1(IS_ACCESS_BY)
indextype is ctxsys.context
parameters( 'datastore foo_user_datastore lexer my_lexer')

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-04030: out of process memory when trying to allocate 65036 bytes
(callheap,KQL tmpbuf)

ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRUE"
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 353 ORA-04030: out of process memory when trying to allocate 65036 bytes
(callheap,KQL tmpbuf)

ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRUE"
ORA-06512: at "CTXSYS.DRVDDL", line 706
ORA-04030: out of process memory when trying to allocate 65036 bytes
(callheap,KQL tmpbuf)

ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRUE"
ORA-06512: at "CTXSYS.DRVDISP", line 104 ORA-04030: out of process memory when trying to allocate 65036 bytes
(callheap,KQL tmpbuf)

ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRUE"
ORA-06512: at "CTXSYS.DRVDISP", line 156 ORA-04030: out of process memory when trying to allocate 65036 bytes
(callheap,KQL tmpbuf)

ORA-06508: PL/SQL: could n Received on Sat Mar 07 2009 - 20:30:04 CST

Original text of this message