Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

CTXCAT index problem: SUBSTRING_INDEX parameter doesn't work

549734Dec 4 2006 — edited Dec 5 2006
Hi,

I need a help with ctxcat index on Oracle 10g. I need to improve searching using CTXCAT index. All is working quite well except SUBSTRING_INDEX parameter. I thought that following was necessary and sufficient:

EXEC ctx_ddl.create_preference('KEVFT_WL', 'BASIC_WORDLIST');
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'substring_index', 'YES');
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'prefix_index', 'YES');
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'prefix_min_length', 1);
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'prefix_max_length', 6);

This BASIC_WORDLIST preference set is used for index creation. But the problem is, that when I try to search using query:

SELECT * FROM TMP_FULLTEXT
WHERE CATSEARCH(fulltext, '%abc', null)> 0;

then I get no rows in results. Despite the fact that row with the text 'aabc' exists in the table.
Can anyone tell me what the problem is?

Thank you,

Julius Chrobak
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2007
Added on Dec 4 2006
3 comments
2,610 views