Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> create table question (interMedia)

create table question (interMedia)

From: G M <zlmei_at_hotmail.com>
Date: 7 May 2002 14:15:59 -0700
Message-ID: <50a5e6b6.0205071315.4e1ea4ab@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 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


Received on Tue May 07 2002 - 16:15:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US