Re: text

sw wrote:
> Hello,
>
> I have installed oracle xe 10g on linux debian. I'm trying to scan a word
> files using context index, it is my code:
>
> CREATE INDEX file_index ON files(path) INDEXTYPE IS ctxsys.context
> PARAMETERS
>
> ('datastore ctxsys.file_datastore format column ot_format');
>
> Path is a real path to word file on disk. But indexing process isn't
> finishing success, because when I execute:
>
> select *
>
> from ctx_user_index_errors
>
> I see a lot of error's DRG-11207 and information that documents was not
> indexing.
>
> I have read that it's a bug oracle 9 database, additional I have found
> instruction how to resolve this problem. There was path also, which I have
> installed. It's doesn't help me. Could you help me?
>

Does this work? Never thought so.

I thought just the file datastore worked... Like:

begin
ctx_ddl.create_preference('mypref', 'FILE_DATASTORE'); ctx_ddl.set_attribute('mypref', 'PATH', '/docs'); end;

But still, filenames should be in a table. Same example:

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

Index creation would be:
create index myindex on mytable(docs)
  indextype is ctxsys.context
  parameters ('datastore mypref');

There's an example, just like this on
http://download.oracle.com/docs/cd/B10501_01/text.920/a96518/cdatadic.htm#44618

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...