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

[Message index]

		create index on clob field as indextype ctxcat does not seem to work By: L_Powell on Tue, 14 August 2007 14:43
		Re: create index on clob field as indextype ctxcat does not seem to work By: ebrian on Thu, 16 August 2007 23:24
		Re: create index on clob field as indextype ctxcat does not seem to work By: L_Powell on Fri, 17 August 2007 12:40

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: Fri Apr 26 02:13:42 CDT 2024