CTXCAT index problem: SUBSTRING_INDEX parameter doesn't work
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: CTXCAT index problem: SUBSTRING_INDEX parameter doesn't work

  1. #1
    Join Date
    Dec 2006
    Posts
    2

    CTXCAT index problem: SUBSTRING_INDEX parameter doesn't work

    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

  2. #2
    Join Date
    Dec 2006
    Posts
    2

    I would appreciate ANY idea or help

    So, It seems like my problem is not solvable :(
    Please if someone has any idea, any question or any help, please write it down.

    I am still searching for the solution, but I am getting crazy :(

    Thanx a lot for ANY help.


    Julius Chrobak

  3. #3
    Join Date
    Dec 2006
    Location
    hyderabad
    Posts
    21
    I am not to sure but how could you give null in the where condition when null is a system generated value

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width