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

From: Vladimir M. Zakharychev <>
Date: Mon, 16 Nov 2009 08:19:51 -0800 (PST)
Message-ID: <>

On Nov 16, 9:12 am, Clarke <> wrote:
> 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;
> nothhing (doth documents contain "Solaris")
> What do I do wrong?

Make sure Oracle can read that directory (OS may prevent it from doing so, so check your file system permissions.) Oracle instance runs with privileges and permissions of Oracle software owner and in order for the instance to be able to access your files this user should be able to read the directory and files in it.


   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm) Received on Mon Nov 16 2009 - 10:19:51 CST

Original text of this message