Re: create table question (interMedia)

zlmei_at_hotmail.com (G M) wrote in message news:<50a5e6b6.0205071315.4e1ea4ab_at_posting.google.com>...
> Hi:
>
> I got the following error when trying to create a table in our oracle 8173 database:
>
> SQL> select count(*) from core_ref;
>
> COUNT(*)
> ----------
> 723566
>
> SQL> select count(*) from disease_category;
>
> COUNT(*)
> ----------
> 132
>
> SQL> desc core_ref;
> Name Null? Type
> ----------------------------------------- -------- ----------------------------
> REFID NOT NULL NUMBER
> TITLE VARCHAR2(1600)
> JOURNALID NUMBER
> YEAR NUMBER
> ABSTRACT VARCHAR2(4000)
>
> SQL> desc disease_category;
> Name Null? Type
> ----------------------------------------- -------- ----------------------------
> DISEASE NOT NULL VARCHAR2(60)
> CATEGORY VARCHAR2(40)
>
> SQL> create table t1 as select refid, disease from core_ref,
> disease_category 2
> create table t1 as select refid, disease from core_ref,
> *where contains (abstract, disease) >0;
> 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
>
>
> But the same sql statement works in another 816 database.
>
> Any suggestions? TIA.
>
> Guang
> ------------

Try to use two contains.

where contains (abstract,'XXXXX') >0 or contains (diseases,'YYYYYY') >0;

Young. Received on Tue May 07 2002 - 22:38:47 CDT