File datastore- what do I do wrong?
722040Nov 16 2009 — edited Nov 20 2009Hi!
I'm 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 (both documents contain "Solaris")
What do I do wrong?
Thanks in advance