help (interMedia Text)

From: James B D Joshi <joshij_at_hermes.ecn>
Date: Thu, 27 May 1999 21:06:02 -0500
Message-ID: <374DFA0A.E9B3D251_at_hermes.ecn>


I need some help in CREATE INDEXing in Oracle8i. Here is a test table and values inserted into it


create table docs
 id number primary key,
 format varchar2(30),
 doc BFILE

create or replace directory docs_dir AS

insert into docs (id, format, doc)
values (1, 'ascii', bfilename('docs_dir','compilation.ascii'));

insert into docs (id, format, doc)
values (2, 'word', bfilename('docs_dir','paper.doc'));

insert into docs (id, format, doc)
values (3, 'postscript', bfilename('docs_dir','')); <<<<<

After this when I try to create index as follows

   create index mindex on docs(doc) indextype is ctxsys.context    parameters('datastore CTXSYS.FILE_DATASTORE'); <<<<<

I get the following error:

ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: ConText error:
DRG-10581: indirect datastores cannot be used with long or lob text
ORA-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at line 1

If you have some idea as to what might be the problem please help me.

-James Received on Fri May 28 1999 - 04:06:02 CEST

Original text of this message