OraFAQ Forum: Text & interMedia » create index on clob field as indextype ctxcat does not seem to work

Home » Server Options » Text & interMedia » create index on clob field as indextype ctxcat does not seem to work

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create index on clob field as indextype ctxcat does not seem to work [message #259224]

Tue, 14 August 2007 14:43

L_Powell
Messages: 2
Registered: August 2007

Junior Member

Hello all,

I'm attempting to query multiple clob fields and just using the normal like '%whatever text%' falls way short of my needs.

I found the Oracle Text as an option and after some pain I am starting to get my legs under me on this.

I am however getting an error when I attempt to create an index on the first of the clob fields in the script below:

CREATE INDEX ctx_narr_test ON narra_data_test(narr_final) INDEXTYPE IS CTXSYS.CTXCAT PARAMETERS ('index set narra_test_iset');

Should I user a different index type than CTXSYS.CTXCAT?

Thanks,

Report message to a moderator

Re: create index on clob field as indextype ctxcat does not seem to work [message #259951 is a reply to message #259224]

Thu, 16 August 2007 23:24

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What error are you getting? Let me guess:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10509: invalid text column: NARR_FINAL
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CATINDEXMETHODS", line 97

If so, you may want to consider a CONTEXT index due to the fact that CTXCAT only supports CHAR or VARCHAR2 data types.

Report message to a moderator

Re: create index on clob field as indextype ctxcat does not seem to work [message #260195 is a reply to message #259224]

Fri, 17 August 2007 12:40

L_Powell
Messages: 2
Registered: August 2007

Junior Member

Yes, apparently CONTENT is what I needed to use.

Thanks

Report message to a moderator

Previous Topic:	creating of the word-frequency histogram from the Oracle Text
Next Topic:	DML Pending queue dr$k table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 19:12:49 CST 2025