| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Install InterMedia Text Thesaurus
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_01C0879C.B364FF84
Content-Type: text/plain;
charset="iso-8859-1"
Hi Jack,
You need to create the DEFAULT thesaurus. Here's the command:
EXEC CTXSYS.CTX_THES.CREATE_THESAURUS('DEFAULT');
It does not need to be owned by CTXSYS. Mine isn't. The thesaurus also
doesn't require a whole lot of storage. After created, you can add entries
with the procedure below or you can import a thesaurus. If you import, the
thesaurus can't exist prior to import. You have to let the import create
the thesaurus for you. You also can't append to a thesaurus via import
(stupid!!)
We got our lists of words by crawling some dictionary and thesaurus sites.
HOwever, the results were marginal. We have some pretty weird relations in
our thesaurus, and no one here is assigned to put acronyms in the thesaurus
(like PS2 = Play Station 2 or OS = Operating System or auto = car) because
we are incredibly short staffed.
This is the awk script I ran against a text file of pairs of words. If you have any other questions I'd be glad to help you.
{
print "exec ctxsys.ctx_thes.create_phrase('DEFAULT','" $1 "') "
print "/"
print "exec ctxsys.ctx_thes.create_phrase('DEFAULT','" $2 "') "
print "/"
print "exec ctxsys.ctx_thes.create_relation('DEFAULT','" $1 "','RT','" $2
"') "
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: Jack C. Applewhite [mailto:japplewhite_at_inetprofit.com]
Sent: Thursday, January 25, 2001 4:46 PM
To: Multiple recipients of list ORACLE-L
Subject: Install InterMedia Text Thesaurus
If you know how to install and/or reinstall the default thesaurus for Intermedia Text on 8.1.6, please share with me.
I've done several successful installs (at least no errors) of 8.1.6 with the InterMedia Text Option enabled. We've got an 8.1.6 DB on Win2k containing a large partitioned table with an InterMedia index on a CLOB column. It's all working fine - we've been doing CONTAINS searches for several months.
While investigating why our ABOUT query results don't seem very good, I used the CTX_THES package and got the error message: "DRG-11702: thesaurus DEFAULT does not exist". A query of CTX_THESAURI returns no rows, as does a query of CTX_USER_THESAURI. Looking in the InterMedia Text Manager shows no Thesauri either and the option to import/export is greyed out.
The docs don't say much except that you can load your own thesaurus with ctxload - they don't say how to load or reload the default thesaurus. I guess it should have been done during database creation, but I can't find anything that looks like the default thesaurus, except for a couple of little files in the ORA81\ctx\samples\thes directory.
Anybody know where the default thesaurus file is?
Thanks.
Jack
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: japplewhite_at_inetprofit.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-LReceived on Fri Jan 26 2001 - 07:34:25 CST
(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_01C0879C.B364FF84 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.2650.12"> <TITLE>RE: Install InterMedia Text Thesaurus</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Hi Jack, </FONT> </P> <P><FONT SIZE=3D2>You need to create the DEFAULT thesaurus. = Here's the command:</FONT> </P> <P><FONT SIZE=3D2>EXEC = CTXSYS.CTX_THES.CREATE_THESAURUS('DEFAULT');</FONT> </P> <P><FONT SIZE=3D2>It does not need to be owned by CTXSYS. Mine = isn't. The thesaurus also doesn't require a whole lot of = storage. After created, you can add entries with the procedure = below or you can import a thesaurus. If you import, the thesaurus = can't exist prior to import. You have to let the import create = the thesaurus for you. You also can't append to a thesaurus via = import (stupid!!)</FONT></P> <P><FONT SIZE=3D2>We got our lists of words by crawling some dictionary = and thesaurus sites. HOwever, the results were marginal. We have = some pretty weird relations in our thesaurus, and no one here is = assigned to put acronyms in the thesaurus (like PS2 =3D Play Station 2 = or OS =3D Operating System or auto =3D car) because we are incredibly = short staffed. </FONT></P> <P><FONT SIZE=3D2>This is the awk script I ran against a text file of = pairs of words. If you have any other questions I'd be glad to = help you. </FONT></P> <P><FONT SIZE=3D2>{</FONT> <BR><FONT SIZE=3D2> print "exec = ctxsys.ctx_thes.create_phrase('DEFAULT','" $1 "') = "</FONT> <BR><FONT SIZE=3D2> print "/"</FONT> <BR><FONT SIZE=3D2> print "exec = ctxsys.ctx_thes.create_phrase('DEFAULT','" $2 "') = "</FONT> <BR><FONT SIZE=3D2> print "/"</FONT> <BR><FONT SIZE=3D2> print "exec = ctxsys.ctx_thes.create_relation('DEFAULT','" $1 = "','RT','" $2 "') "</FONT> <BR><FONT SIZE=3D2> print "/"</FONT> <BR><FONT SIZE=3D2> print "exec = ctxsys.ctx_thes.create_relation('DEFAULT','" $2 = "','RT','" $1 "') "</FONT> <BR><FONT SIZE=3D2> print "/"</FONT> <BR><FONT SIZE=3D2>}</FONT> </P> <BR> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."</FONT></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Jack C. Applewhite [<A = HREF=3D"mailto:japplewhite_at_inetprofit.com">mailto:japplewhite_at_inetprofit= .com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, January 25, 2001 4:46 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Install InterMedia Text Thesaurus</FONT> </P> <BR> <P><FONT SIZE=3D2>If you know how to install and/or reinstall the = default</FONT> <BR><FONT SIZE=3D2>thesaurus for Intermedia Text on 8.1.6, please share = with</FONT> <BR><FONT SIZE=3D2>me.</FONT> </P> <P><FONT SIZE=3D2>I've done several successful installs (at least no = errors)</FONT> <BR><FONT SIZE=3D2>of 8.1.6 with the InterMedia Text Option = enabled. We've got</FONT> <BR><FONT SIZE=3D2>an 8.1.6 DB on Win2k containing a large partitioned = table</FONT> <BR><FONT SIZE=3D2>with an InterMedia index on a CLOB column. = It's all working</FONT> <BR><FONT SIZE=3D2>fine - we've been doing CONTAINS searches for = several</FONT> <BR><FONT SIZE=3D2>months.</FONT> </P> <P><FONT SIZE=3D2>While investigating why our ABOUT query results don't = seem</FONT> <BR><FONT SIZE=3D2>very good, I used the CTX_THES package and got the = error</FONT> <BR><FONT SIZE=3D2>message: "DRG-11702: thesaurus DEFAULT does not = exist". A</FONT> <BR><FONT SIZE=3D2>query of CTX_THESAURI returns no rows, as does a = query of</FONT> <BR><FONT SIZE=3D2>CTX_USER_THESAURI. Looking in the InterMedia = Text Manager</FONT> <BR><FONT SIZE=3D2>shows no Thesauri either and the option to = import/export is</FONT> <BR><FONT SIZE=3D2>greyed out.</FONT> </P> <P><FONT SIZE=3D2>The docs don't say much except that you can load your = own</FONT> <BR><FONT SIZE=3D2>thesaurus with ctxload - they don't say how to load = or</FONT> <BR><FONT SIZE=3D2>reload the default thesaurus. I guess it = should have been</FONT> <BR><FONT SIZE=3D2>done during database creation, but I can't find = anything</FONT> <BR><FONT SIZE=3D2>that looks like the default thesaurus, except for a = couple</FONT> <BR><FONT SIZE=3D2>of little files in the ORA81\ctx\samples\thes = directory.</FONT> </P> <P><FONT SIZE=3D2>Anybody know where the default thesaurus file = is?</FONT> </P> <P><FONT SIZE=3D2>Thanks.</FONT> </P> <P><FONT SIZE=3D2>Jack</FONT> </P> <P><FONT SIZE=3D2>--------------------------------</FONT> <BR><FONT SIZE=3D2>Jack C. Applewhite</FONT> <BR><FONT SIZE=3D2>Database Administrator/Developer</FONT> <BR><FONT SIZE=3D2>OCP Oracle8 DBA</FONT> <BR><FONT SIZE=3D2>iNetProfit, Inc.</FONT> <BR><FONT SIZE=3D2>Austin, Texas</FONT> <BR><FONT SIZE=3D2>www.iNetProfit.com</FONT> <BR><FONT SIZE=3D2>japplewhite_at_inetprofit.com</FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Jack C. Applewhite</FONT> <BR><FONT SIZE=3D2> INET: japplewhite_at_inetprofit.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
 |
 |