Home -> Usenet -> c.d.o.server -> Oracle Text: File datastore- what do I do wrong?)

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

From: Clarke <m.derkach_at_gmail.com>
Date: Sun, 15 Nov 2009 22:12:04 -0800 (PST)
Message-ID: <6ac39480-35d1-4d2e-9275-13040fb64dd8_at_s15g2000yqs.googlegroups.com> 





Hi!


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



begin


 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;



...gives 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