Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> create table question (interMedia)
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 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
But the same sql statement works in another 816 database.
Any suggestions? TIA.
Guang