help (interMedia Text)

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
'/home/danpatch/j/joshij/oracle/docs';

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','intermedia.ps')); <<<<<

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:

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 "CTXSYS.TEXTINDEXMETHODS", line 34
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