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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-20000: interMedia Text error, please help

RE: ORA-20000: interMedia Text error, please help

From: SAURY Alain <ASAURY_at_recherche.loreal.com>
Date: Fri, 15 Sep 2000 09:19:40 +0200
Message-Id: <10620.117084@fatcity.com>


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">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2651.75">
<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>
<BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">De:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 = FACE=3D"Arial">Naik, Sandesh [SMTP:Sandesh.Naik_at_compaq.com]</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"Arial">Date:&nbsp;&nbsp;</FONT></B> <FONT = SIZE=3D1 FACE=3D"Arial">mercredi 13 septembre 2000 22:46</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">=C0:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT = SIZE=3D1 FACE=3D"Arial">Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"Arial">Objet:&nbsp;</FONT></B> <FONT = SIZE=3D1 FACE=3D"Arial">ORA-20000: interMedia Text error, please = help</FONT>
</P>

<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">&nbsp;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">&nbsp; INET: =
Sandesh.Naik_at_compaq.com</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Courier New">Fat City Network = Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) = 538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">San Diego, = California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier =

New">-------------------------------------------------------------------=
-</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">To REMOVE yourself from this = mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New">to: ListGuru_at_fatcity.com (note = EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New">the message BODY, include a = line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">(or the name of mailing list = you want to be removed from).&nbsp; You may</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New">also send the HELP command for = Received on Fri Sep 15 2000 - 02:19:40 CDT

Original text of this message

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