Home » Server Options » Text & interMedia » Cannot create text index in partition table on Oracle 10g
Cannot create text index in partition table on Oracle 10g [message #76182] Sun, 30 January 2005 22:16 Go to next message
Edward
Messages: 6
Registered: October 2000
Junior Member
I try to create context index in a table with 15 millions records. The table is divided 5 partitions and each patition has 3 millions records. When I create the context index in the table, the same error always arised. The follow are my work:
--First create my own lexer
begin
ctx_ddl.createperference('my_chinese_lexer','chinese_lexer');
end;
--Second create index
create index idx_part_text3 on tb_test_part(text3)
indextype is ctxsys.context local (
partition p1_ix,
partition p2_ix,
partition p3_ix ,
partition p4_ix,
partition p5_ix)
parameters('lexer my_chinese_lexer') parallel;
-----------------------------
--error message
create index idx_part_text3 on tb_test_part(text3)
*
Error in 1 line:
ORA-12801: Parellel Query Server P000 send error signal
ORA-29855: Error on execute ODCIINDEXCREATE program
ORA-06510: PL/SQL: User Defined Error
ORA-06512: In "CTXSYS.DRIDISP", line 244
ORA-04030: Try to alloc 65548 Bytes (CTX PRM heap,draccbx:message buffer) Out of memory
ORA-06512: In "CTXSYS.DRIPARX", line 10
ORA-06512: In "CTXSYS.TEXTINDEXMETHODS", line 359
ORA-04030: Try to alloc 65548 Bytes (CTX PRM heap,draccbx:message buffer) Out of memory
ORA-06512: In "CTXSYS.DRUE", line 191
ORA-06512: In "CTXSYS.DRUE", line 49
ORA-06512: In "CTXSYS.DRUE", line 24
ORA-06512: In "CTXSYS.DRUE", line 186
ORA-06512: In "CTXSYS.DRVDDL", line 682
ORA-04030: Try to alloc 65548 Bytes (CTX PRM heap,draccbx:message buffer) Out of memory
ORA-04030: Try to alloc 65548 Bytes (CTX PRM heap,draccbx:message buffer) Out of memory
ORA-06512: In "CTXSYS.DRUE", line 191
ORA-06512: In "CTXSYS.DRUE", line 49
ORA-06512: In "CTXSYS.DRUE", line 24
ORA-06512: In "CTXSYS.DRVDDL", line 452
ORA-06510: PL/SQL: User Defined Error
Re: Cannot create text index in partition table on Oracle 10g [message #76183 is a reply to message #76182] Sun, 30 January 2005 22:22 Go to previous messageGo to next message
Edward
Messages: 6
Registered: October 2000
Junior Member
BTW:
My oracle 10g run on linux AS3 box with 4xP4 and 6G Mem.
I set pga_aggregate_target=2200M, and at the beginning of creating index, the max pga alloced is about 1100M, but when one patition finished, the error arised and the max pga alloced suddenly reached 3500M. So in every times, the index status is always like below:
P1_ix usable
P2_ix Inprogress
P3_ix Inprogress
P4_ix Inprogress
P5_ix Inprogress
Re: Cannot create text index in partition table on Oracle 10g [message #205929 is a reply to message #76183] Tue, 28 November 2006 03:09 Go to previous message
rasikeg@gmail.com
Messages: 4
Registered: November 2006
Location: LK
Junior Member
whats the
cant you try to built the index in parts ?

option 1
=========
create index tdrbip02bx on tdrbip02b(text)
indextype is ctxsys.context local (partition tdrbip02bx1,
partition tdrbip02bx2,partition tdrbip02bx3)
unusable;

exec
dbms_pclxutil.build_part_index(3,2,'TDRBIP02B','TDRBIP02BX',TRUE);

option 2
=========
create index ptestx on ptest(text)
indextype is ctxsys.context
local
parameters ('NOPOPULATE');

alter index ptestx rebuild partition p1;

or if you wann add bit more power

alter index ptestx rebuild partition p1 parameters ('replace memory 50M');

Previous Topic: Partionning table and index with Oracle text
Next Topic: Oracle Text "starts with" search
Goto Forum:
  


Current Time: Thu Mar 28 14:57:29 CDT 2024