Home » Server Options » Text & interMedia » create index on clob field as indextype ctxcat does not seem to work
create index on clob field as indextype ctxcat does not seem to work [message #259224] Tue, 14 August 2007 14:43 Go to next message
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,
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 Go to previous messageGo to next message
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.
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 Go to previous message
L_Powell
Messages: 2
Registered: August 2007
Junior Member
Yes, apparently CONTENT is what I needed to use.

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


Current Time: Thu Mar 28 06:38:37 CDT 2024