Re: create table question (interMedia)

I think your contains clause is wrong. It should look like this:

select ...
from table
where contains (abstract, 'disease') >0;

contains syntax is COMTAINS (<indexnamd>,'<tokens>')>0

Cheers
Thomas

> SQL> create table t1 as select refid, disease from core_ref,
> disease_category where contains (abstract, disease) >0; 2
> create table t1 as select refid, disease from core_ref,
> *
> ERROR at line 1:
> ORA-29902: error in executing ODCIIndexStart() routine
> ORA-20000: interMedia Text error:
> DRG-50900: text query parser error on line 1, column 32
> DRG-50920: part of phrase not itself a phrase or equivalence
Received on Tue May 07 2002 - 17:08:16 CDT