Re: interMedia doesn't find my text

If you are looking for documentation see:

technet.oracle.com -> products -> Oracle Text

Best is to start with 8.1.5 docu, there are the basics explained.

Thomas

Ronaldo wrote:
>
> 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

-- 
---------------------------
Thomas Hesse
Systems Support Specialist
Oracle DBA
Xtra Limited
http://www.xtra.co.nz
---------------------------