Re: interMedia doesn't find my text

From: Ronaldo <ronaldo.mercado_at_gmx.net>
Date: 23 Jan 2002 00:57:07 -0800
Message-ID: <4c74245d.0201230057.1986c980@posting.google.com>

Thanks for your insight. My results look much better now and I'm glad that I can finally see what words are being indexed. I've set up the datastore, filter, lexer, section group, and wordlist.
I couldn't tell Oracle to use the DEFAULT_STOPLIST, but the results look fine so far.

My next step is highlighting. I hope things roll smoothly.

Cheers,
Ronaldo

--datastore

exec ctx_ddl.drop_preference('contest_datastore');
exec ctx_ddl.create_preference('contest_datastore','USER_DATASTORE');
exec ctx_ddl.set_attribute('contest_datastore', 'procedure',

's_p_contest');
exec ctx_ddl.set_attribute('contest_datastore', 'output_type', 'clob');

--filter
exec ctx_ddl.Drop_Preference ('contest_filter'); exec ctx_ddl.Create_Preference ('contest_filter','NULL_FILTER');

--section group
exec ctx_ddl.drop_section_group ('contest_section'); exec ctx_ddl.create_section_group
('contest_section','NULL_SECTION_GROUP');

--lexer

exec CTX_DDL.drop_preference('contest_lexer');
exec CTX_DDL.create_preference('contest_lexer','BASIC_LEXER');
exec CTX_DDL.set_attribute('contest_lexer','BASE_LETTER','YES');
exec CTX_DDL.set_attribute('contest_lexer','MIXED_CASE',  'NO');
exec CTX_DDL.set_attribute('contest_lexer','INDEX_THEMES','NO');
exec CTX_DDL.set_attribute('contest_lexer','INDEX_TEXT', 'YES');

--wordlist

exec ctx_ddl.drop_preference('contest_wordlist');
exec CTX_DDL.create_preference('contest_wordlist','BASIC_WORDLIST');
exec CTX_DDL.set_attribute('contest_wordlist','STEMMER','ENGLISH');

create index i_contest_text
on contest_text(body_text)
indextype is ctxsys.context
parameters ('datastore contest_datastore filter contest_filter lexer contest_lexer wordlist contest_wordlist section group contest_section memory 20M ');

Thomas Hesse <thomas.hesse_at_team.xtra.co.nz> wrote in message news:<3C4DE16D.90D4C5B1_at_team.xtra.co.nz>...
> You can see the tokens with
>
> select token_text from dr$<index>$i;
>
> I think you should also define all the others preferences, but
> at least LEXER, FILTER and SECTION:
>
> -- Create Preferences
> exec CTX_DDL.drop_preference('MY_LEXER');
> exec CTX_DDL.create_preference('MY_LEXER','BASIC_LEXER');
> exec CTX_DDL.set_attribute('MY_LEXER','BASE_LETTER','YES');
> exec CTX_DDL.set_attribute('MY_LEXER','MIXED_CASE', 'NO');
> exec CTX_DDL.set_attribute('MY_LEXER','INDEX_THEMES','NO');
> exec CTX_DDL.set_attribute('MY_LEXER','INDEX_TEXT', 'YES');
> exec ctx_ddl.Drop_Preference ('MY_FILTER');
> exec ctx_ddl.Create_Preference ('MY_FILTER','NULL_FILTER');
> exec ctx_ddl.drop_section_group ('MY_SECTION');
> exec ctx_ddl.create_section_group ('MY_SECTION','NULL_SECTION_GROUP');
>
> create index i_test on test (text)
> indextype is ctxsys.context
> parameters ('lexer MY_LEXER filter MY_FILTER section group MY_SECTION
> memory 20M');
>
>
> Cheers
> Thomas
Received on Wed Jan 23 2002 - 02:57:07 CST