Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-20000: interMedia Text error, please help
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C01EE5.501E7010
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
You are using an SQL syntax that refers to an InterMedia Index (for ex,
CONTAINS clause), but you don't have an InterMedia index for that =
column.
See InterMedia help for creating the index.
Alain
-----Message d'origine----- De: Naik, Sandesh [SMTP:Sandesh.Naik_at_compaq.com] Date: mercredi 13 septembre 2000 22:46 =C0: Multiple recipients of list ORACLE-L Objet: ORA-20000: interMedia Text error, please help We are getting following error while connecting to Intermedia. Is there any way to tell what this error in Intermedia is?=20 com.requisite.bugsi.engine.TextSearchException: ORA-20000: interMedia Text error: DRG-10599: column is not indexed Thanks -Sandesh N. Oracle DBA , Compaq --=20 Author: Naik, Sandesh INET: Sandesh.Naik_at_compaq.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
------_=_NextPart_001_01C01EE5.501E7010
Content-Type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3Diso-8859-1">
<TITLE>RE: ORA-20000: interMedia Text error, please help</TITLE> </HEAD> <BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">You are using an SQL syntax that = refers to an InterMedia Index (for ex, CONTAINS clause), but you don't = have an InterMedia index for that column. See InterMedia help for = creating the index.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Alain</FONT> </P> <UL> <P><A NAME=3D"_MailData"><FONT SIZE=3D1 FACE=3D"Arial">-----Message =d'origine-----</FONT></A>
<P><FONT SIZE=3D2 FACE=3D"Courier New">We are getting following error =
while connecting to Intermedia.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">Is there any way to tell what =
this error in Intermedia is? </FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier =
New">com.requisite.bugsi.engine.TextSearchException: ORA-20000: =
interMedia Text</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">error:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">DRG-10599: column is not =
indexed</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">Thanks</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New">-Sandesh N.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> Oracle DBA , =Compaq</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">-- </FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New">Author: Naik, Sandesh</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> INET: =Sandesh.Naik_at_compaq.com</FONT>
<P><FONT SIZE=3D2 FACE=3D"Courier New">Fat City Network =
Services -- (858) 538-5051 FAX: (858) =
538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier =
New">-------------------------------------------------------------------=-</FONT>