Oracle Text: File datastore- what do I do wrong?)

From: Clarke <>
Date: Sun, 15 Nov 2009 22:12:04 -0800 (PST)
Message-ID: <>

Im trying to index .doc and .txt files using Oracle Text:

 ctx_ddl.create_preference('COMMON_DIR','FILE_DATASTORE');  ctx_ddl.set_attribute('COMMON_DIR','PATH','/home/max/doc'); end;

create table mytable(id number primary key, docs varchar2(2000)); insert into mytable values(111555,'1.txt'); insert into mytable values(111556,'best.doc'); commit;

create index myindex on mytable(docs)
  indextype is ctxsys.context
  parameters ('datastore COMMON_DIR');

And the query

SELECT SCORE(1), id, docs FROM mytable WHERE CONTAINS(docs, 'Solaris', 1) > 0; nothhing (doth documents contain "Solaris")

What do I do wrong? Received on Mon Nov 16 2009 - 00:12:04 CST

Original text of this message