intermedia?
hi oracle gurus, does anyone knows anything about 'intermedia' ? how can I find materials about it. My client is going to buy it and I want to have a jump start. If you have any documents (electronic ones) ,or know any URL that helps,please send it to me and I'll be grateful. Oracle dba Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MOHAMMAD AMER INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia
Does anyone have instructions or know where to find concise instructions on setting up the Intermedia database objects (i.e. CTXSYS and what not) in an 8.1.6 instance? Like what scripts to run or is there a utility. TIA Bryan M. Miller Junior Oracle DBA IT Operations Telergy Inc. Email: [EMAIL PROTECTED] Phone: (315)362-2642 Pager: (315)647-1908 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Bryan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
interMedia Text
Dear List, We have :- Solaris SunOs 5.8, Oracle 8.1.7 I have created three databases using the dbassist tool and I included, as one of the installation options, InterMedia. Having read the installation guides (including post installation for Oracle InterMedia) and the Oracle interMedia Text - 8.1.5 Overview "Post Installation Setup" I have the following questions :- 1) Having amended the "listener.ora" and "tnsnames.ora" files I'm not sure if I have done this correctly because the "Post Installation Setup" refers to adding ONE entry (for extproc_connection_data) in the tnsnames.ora file for A database. But I have three, so I have entered this SID specific info. three times, is this correct ? 2) Having amended the listener.ora file to contain three extra entries is this correct ? 3) I remember one of the NET8 classes I took, where the instructor insisted that we amend these files with great caution and in particular to the layout of entries. e.g. the number of spaces etc. etc. Well the new entries I added don't conform exactly to the already existing entries, here is a snip of my listener.ora file SID_LIST_LISTENER (SID_LIST (SID_DESC (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/8.1.7) (PROGRAM = extproc) ) (SID_DESC (GLOBAL_DBNAME = RATREP) (ORACLE_HOME = /u01/app/oracle/product/8.1.7) (SID_NAME = RATREP) ) (SID_DESC (GLOBAL_DBNAME = CQPROD01) (ORACLE_HOME = /u01/app/oracle/product/8.1.7) (SID_NAME = CQPROD01) ) (SID_DESC (GLOBAL_DBNAME = CQTEST01) (ORACLE_HOME = /u01/app/oracle/product/8.1.7) (SID_NAME = CQTEST01) ) (SID_DESC = (SID_NAME = ep_agt1) (ORACLE_HOME = /u01/app/oracle/product/8.1.7) (ENVS = LD_LIBRARY_PATH=/u01/app/oracle/product/8.1 7/ctx/lib) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = ep_agt2) (ORACLE_HOME = /u01/app/oracle/product/8.1.7) (ENVS = LD_LIBRARY_PATH=/u01/app/oracle/product/8.1 7/ctx/lib) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = ep_agt3) (ORACLE_HOME = /u01/app/oracle/product/8.1.7) (ENVS = LD_LIBRARY_PATH=/u01/app/oracle/product/8.1 7/ctx/lib) (PROGRAM = extproc) ) ) You can see that the SID_DESC entries layout are slightly different that those earlier, is this OK? Thanks in advance, and sorry in advance if any of the above questions are dumb, but I'm a bit stuck on this! best regards, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MCUK INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia question
Hi, Does anyone know the maximum character length for index name for intermedia index. I'm trying to create intermedia index with the index name length of 24 characters, my index name is title_creators_ind_index and getting drg-11439 "index name length exceeds maximum of 25 characters" error. I'm using Oracle 8.1.6 on Sun Solaris 2.7 Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia Indexing
Hi, We have an Oracle iFS installation and have enabled Intermedia. Some documents fail indexing with "Status 1" or "Status 2" errors. The documents are PDF (pdf 1.3), Excel, World and HTM documents. I do have a TAR open with Support. Just would like to know from the field .... how successful is Intermedia in indexing documents ? Are there any "gotchas" ? Oracle8i 8.1.7.3 on Solaris for iFS9.0.1 Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
InterMedia Gurus
Any one you guys/dolls out there who are really using InterMedia, this one is for you Have you come across a good, single user scanner/OCR combo for putting hardcopy into a db under InterMedia? I have a bunch of dox i'd like to put on a CD or DVD, but want very high quality OCR and don't want to spend the next twelve thousand sidereal cycles scanning and correcting OCR input. So..."what do you like?" TIA, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia question
Good day, I have an application that has many documents (Word, Excel, pdf, email etc) stored on a Solaris file system. I want to be able to search the contents of those document. Is it possible to create some tables in the database that has BFILE columns that reference those documents outside the database and use InterMedia to do searching? I am not familiar with LOBs and Intermedia, that's why I ask this basic question. Thanks Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia application
Hi there, An application running the Intermedia process ctxhx is seen to b consuming an unusually high CPU time thus preventing other applications from running. Being very new to Intermedia I do not why this is happening. Can somebody help me on how to diagnose the problem of high CPU usage by ctxhx and correct it ?? Any help will be greatly appreciated. Thanks. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia
Solaris. -Original Message- Sent: Monday, May 14, 2001 10:11 AM To: Multiple recipients of list ORACLE-L Bryan, What O/S are you on? I had specific problems with the intermedia install on HP/UX that required some changes in the install procedure, per support. I have a few scripts - if you would like me to send them to you, please email me directly. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com < http://www.neom.com <http://www.neom.com> > www.paperclick.com < http://www.paperclick.com <http://www.paperclick.com> > www.qode.com < http://www.qode.com <http://www.qode.com> > P a p e r C l i c k . c o m < http://www.paperclick.com/home.htm <http://www.paperclick.com/home.htm> > Enter Your PaperClick Code Here! -Original Message- <mailto:[EMAIL PROTECTED]> ] Sent: Friday, May 11, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Does anyone have instructions or know where to find concise instructions on setting up the Intermedia database objects (i.e. CTXSYS and what not) in an 8.1.6 instance? Like what scripts to run or is there a utility. TIA Bryan M. Miller Junior Oracle DBA IT Operations Telergy Inc. Email: [EMAIL PROTECTED] Phone: (315)362-2642 Pager: (315)647-1908 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Miller, Bryan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Bryan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia
Lisa, I just went through Intermedia install on HPUX 11 and Ora 8.1.6 (32 bit) with no apparent problems. Been able to create Intermedia indexes and all is working well. Could you share what problems you've encountered? Thanks, Gary Weber -Original Message- Sent: Monday, May 14, 2001 10:11 AM To: Multiple recipients of list ORACLE-L Bryan, What O/S are you on? I had specific problems with the intermedia install on HP/UX that required some changes in the install procedure, per support. I have a few scripts - if you would like me to send them to you, please email me directly. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com < http://www.neom.com <http://www.neom.com> > www.paperclick.com < http://www.paperclick.com <http://www.paperclick.com> > www.qode.com < http://www.qode.com <http://www.qode.com> > P a p e r C l i c k . c o m < http://www.paperclick.com/home.htm <http://www.paperclick.com/home.htm> > Enter Your PaperClick Code Here! -Original Message- <mailto:[EMAIL PROTECTED]> ] Sent: Friday, May 11, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Does anyone have instructions or know where to find concise instructions on setting up the Intermedia database objects (i.e. CTXSYS and what not) in an 8.1.6 instance? Like what scripts to run or is there a utility. TIA Bryan M. Miller Junior Oracle DBA IT Operations Telergy Inc. Email: [EMAIL PROTECTED] Phone: (315)362-2642 Pager: (315)647-1908 -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia
Title: RE: Intermedia Hi Gary, This is what happened. A regular install would not succeed with the CREATE INDEX statement. I put a call in to support. Lucky for me I got a knowledgeable woman on the phone who knew exactly what the problem was. The libraries could not be created when $ORACLE_HOME was referenced in the install scripts. I had to hard-code the library name with the value for $ORACLE_HOME. Now that I look through my script, that was the only thing that got hosed. After I made that change everything was fine. Hope this helps someone... Have a great day all ! ** cr_ctxsys.sql spool cr_ctxsys.log @$ORACLE_HOME/ctx/admin/dr0csys.sql ctxsys drsys temp connect ctxsys/ctxsys @$ORACLE_HOME/ctx/admin/dr0inst.sql $ORACLE_HOME/ctx/lib/libctxx8.sl prompt Check install select library_name,file_spec,dynamic,status from user_libraries; prompt Set US default preferences @$ORACLE_HOME/ctx/admin/defaults/drdefus.sql create or replace library DR$LIBX as '/oracle/dbserver/8.1.6/ctx/lib/libctxx8.sl' / -Original Message- From: Gary Weber [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 4:46 PM To: Multiple recipients of list ORACLE-L Subject: RE: Intermedia Lisa, I just went through Intermedia install on HPUX 11 and Ora 8.1.6 (32 bit) with no apparent problems. Been able to create Intermedia indexes and all is working well. Could you share what problems you've encountered? Thanks, Gary Weber -Original Message- Sent: Monday, May 14, 2001 10:11 AM To: Multiple recipients of list ORACLE-L Bryan, What O/S are you on? I had specific problems with the intermedia install on HP/UX that required some changes in the install procedure, per support. I have a few scripts - if you would like me to send them to you, please email me directly. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com < http://www.neom.com <http://www.neom.com> > www.paperclick.com < http://www.paperclick.com <http://www.paperclick.com> > www.qode.com < http://www.qode.com <http://www.qode.com> > P a p e r C l i c k . c o m < http://www.paperclick.com/home.htm <http://www.paperclick.com/home.htm> > Enter Your PaperClick Code Here! -Original Message- <mailto:[EMAIL PROTECTED]> ] Sent: Friday, May 11, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Does anyone have instructions or know where to find concise instructions on setting up the Intermedia database objects (i.e. CTXSYS and what not) in an 8.1.6 instance? Like what scripts to run or is there a utility. TIA Bryan M. Miller Junior Oracle DBA IT Operations Telergy Inc. Email: [EMAIL PROTECTED] Phone: (315)362-2642 Pager: (315)647-1908 -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: intermedia?
Hi, the documentation for Oracle Intermedia (formerly ConText) is included in the Oracle server's documentation set. If you don't have it available yet, take a look at technet.oracle.com. There you can find all documentation sets online. MOHAMMAD AMER schrieb: > > hi oracle gurus, > does anyone knows anything about 'intermedia' ? how can I find materials about > it. > My client is going to buy it and I want to have a jump start. > If you have any documents (electronic ones) ,or know any URL that helps,please > send it to me and I'll be grateful. >Oracle dba > > > Get free email and a permanent address at http://www.netaddress.com/?N=1 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: MOHAMMAD AMER > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > > --- > This Mail has been checked for Viruses > Attention: Encrypted Mails can NOT be checked ! > > *** > > Diese Mail wurde auf Viren ueberprueft > Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! > -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Intermedia
Bryan, A good start is Note: 101493.1 "QUICK START GUIDE: InterMedia Text Installation" There are others on metalink: Technical Libraries button Server -> Oracle interMedia Text and ConText Option HTH, -- Anita --- "Miller, Bryan" <[EMAIL PROTECTED]> wrote: > Does anyone have instructions or know where to find > concise instructions on > setting up the Intermedia database objects (i.e. > CTXSYS and what not) in an > 8.1.6 instance? Like what scripts to run or is there > a utility. > TIA > Bryan M. Miller > Junior Oracle DBA > IT Operations > Telergy Inc. > Email: [EMAIL PROTECTED] > Phone: (315)362-2642 > Pager: (315)647-1908 > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Miller, Bryan > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia
To install Intermedia as a separate product, the db has to be shutdown for oracle exe to be relinked Once the Intermedia product has been installed, the following steps must be performed to configure it as shown below. How to configure Intermedia? Create the CTXSYS tablespace create tablespace ctxsys datafile '/u02/oradata/dev/ctxsys01.dbf' size 100M autoextend on next 100M maxsize 1000M; export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/ctx/lib 548:oracle@devdb> pwd /u01/app/oracle/product/8.1.7/ctx/admin As sys run @dr0csys.sql ctxsys ctxsys temp As ctxsys @dr0inst.sql /u01/app/oracle/product/8.1.7/ctx/lib/libctxx8.so As ctxsys select object_type, count(*) from user_objects group by object_type; select * from user_libraries ; @?/ctx/admin/defaults/drdefus.sql > -Original Message- > From: A. Bardeen [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 11, 2001 4:18 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Intermedia > > > Bryan, > > A good start is Note: 101493.1 "QUICK START GUIDE: > InterMedia Text Installation" > > There are others on metalink: > > Technical Libraries button > Server -> Oracle interMedia Text and ConText Option > > HTH, > > -- Anita > > --- "Miller, Bryan" <[EMAIL PROTECTED]> wrote: > > Does anyone have instructions or know where to find > > concise instructions on > > setting up the Intermedia database objects (i.e. > > CTXSYS and what not) in an > > 8.1.6 instance? Like what scripts to run or is there > > a utility. > > TIA > > Bryan M. Miller > > Junior Oracle DBA > > IT Operations > > Telergy Inc. > > Email: [EMAIL PROTECTED] > > Phone: (315)362-2642 > > Pager: (315)647-1908 > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Miller, Bryan > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: A. Bardeen > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinagesh Battula INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia
Title: RE: Intermedia Bryan, What O/S are you on? I had specific problems with the intermedia install on HP/UX that required some changes in the install procedure, per support. I have a few scripts - if you would like me to send them to you, please email me directly. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com <http://www.neom.com> www.paperclick.com <http://www.paperclick.com> www.qode.com <http://www.qode.com> P a p e r C l i c k . c o m <http://www.paperclick.com/home.htm> Enter Your PaperClick Code Here! -Original Message- From: Miller, Bryan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Subject: Intermedia Does anyone have instructions or know where to find concise instructions on setting up the Intermedia database objects (i.e. CTXSYS and what not) in an 8.1.6 instance? Like what scripts to run or is there a utility. TIA Bryan M. Miller Junior Oracle DBA IT Operations Telergy Inc. Email: [EMAIL PROTECTED] Phone: (315)362-2642 Pager: (315)647-1908 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Bryan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia error
Hi all, i have an error message .. i try to connect to my server to check the oracle intermedia is working properly after i rebuild the apache kernel ... i point my browser to http://172.16.0.30/intermedia/~about and i've got an error message ... Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, root@server01 and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Apache/1.3.12 Server at server01.multatuli.com Port 80 Anyone in here ever use the oracle intermedia in linux... ?? I need a sugest .. regards nareswara "I'll be back!" Arnold Schwarzenegger -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia tag "<" problem
Hi Gurus, We are working with Intermedia Text 8.1.6. We created a intermedia index on a search field. We also created 2 sections in this field. Table name : S01 Filed name : S01_search Sections name : SY,MAN Here is an example of data in this field: CyanePhibro Energy * This example works fine. But we have a problem when there is a "<" character in the data. Intermedia thinks it's a new tag and tries to find a section but it cannot. Exemple: Cyane < 10 Phibro Energy * Question : 1- Should we do something with the "<" in our data ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: interMedia Text
As you are running 8.1.7 you should not need the extproc_connection_data entry. What you need is that the LD_LIBRARY_PATH includes $ORACLE_HOME/ctx/lib in the environment *before* you start the Listener. The listener.ora entries are the regular entries for the database SIDs. Hemant At 03:48 AM 12-08-02 -0800, you wrote: >Dear List, >We have :- Solaris SunOs 5.8, Oracle 8.1.7 >I have created three databases using the dbassist tool and I included, as >one of the installation options, InterMedia. >Having read the installation guides (including post installation for Oracle >InterMedia) and the Oracle interMedia Text - 8.1.5 Overview "Post >Installation Setup" I have the following questions :- >1) Having amended the "listener.ora" and "tnsnames.ora" files I'm not sure >if I have done this correctly because the "Post Installation Setup" refers >to adding ONE entry (for extproc_connection_data) in the tnsnames.ora file >for A database. >But I have three, so I have entered this SID specific info. three times, is >this correct ? >2) Having amended the listener.ora file to contain three extra entries is >this correct ? >3) I remember one of the NET8 classes I took, where the instructor insisted >that we amend these files with great caution and in particular to the layout >of entries. e.g. the number of spaces etc. etc. Well the new entries I added >don't conform exactly to the already existing entries, here is a snip of my >listener.ora file >SID_LIST_LISTENER (SID_LIST (SID_DESC (SID_NAME LSExtProc) > (ORACLE_HOME u01/app/oracle/product/8.1.7) > (PROGRAM xtproc) > ) > (SID_DESC (GLOBAL_DBNAME ATREP) > (ORACLE_HOME u01/app/oracle/product/8.1.7) > (SID_NAME ATREP) > ) > (SID_DESC (GLOBAL_DBNAME QPROD01) > (ORACLE_HOME u01/app/oracle/product/8.1.7) > (SID_NAME QPROD01) > ) > (SID_DESC (GLOBAL_DBNAME QTEST01) > (ORACLE_HOME u01/app/oracle/product/8.1.7) > (SID_NAME QTEST01) > ) > (SID_DESC SID_NAME p_agt1) > (ORACLE_HOME u01/app/oracle/product/8.1.7) > (ENVS D_LIBRARY_PATH01/app/oracle/product/8.1 >7/ctx/lib) > (PROGRAM xtproc) > ) > (SID_DESC SID_NAME p_agt2) > (ORACLE_HOME u01/app/oracle/product/8.1.7) > (ENVS D_LIBRARY_PATH01/app/oracle/product/8.1 >7/ctx/lib) > (PROGRAM xtproc) > ) > (SID_DESC SID_NAME p_agt3) > (ORACLE_HOME u01/app/oracle/product/8.1.7) > (ENVS D_LIBRARY_PATH01/app/oracle/product/8.1 >7/ctx/lib) > (PROGRAM xtproc) > ) > ) >You can see that the SID_DESC entries layout are slightly different that >those earlier, is this OK? > >Thanks in advance, and sorry in advance if any of the above questions are >dumb, but I'm a bit stuck on this! > >best regards, > >Ron > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: MCUK > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia question
Hi, Mujeeb, I think, correct answer will be 20. Intermedia creates a bunch of objects in support of domain index. These objects's names are actually prefixed & suffixed Index names - 5 characters overhead. HTH Vadim Gorbounov Master of Oracle DBA www.brainbench.com -Original Message- Sent: Tuesday, August 28, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Hi, Does anyone know the maximum character length for index name for intermedia index. I'm trying to create intermedia index with the index name length of 24 characters, my index name is title_creators_ind_index and getting drg-11439 "index name length exceeds maximum of 25 characters" error. I'm using Oracle 8.1.6 on Sun Solaris 2.7 Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Oracle Intermedia Text
I am using Oracle 8.1.7.2 on Solaris 2.8 Here is the script I am running: === create table testtext ( searchfield varchar(100)); insert into testtext values ('rstephenVb03R/o2Vi7Iwomigod/o/r/rstephen'); insert into testtext values ('gar001wuHkq2GP3o3O.rstephen/o/g/gar001'); create index testtext_idx on testtext(searchfield) indextype is ctxsys.context; column searchfield format a50 PROMPT PROMPT select score(1), searchfield from testtable2 where contains(searchfield,' rstephen' ,1) > 0; select score(1), searchfield from testtable2 where contains(searchfield,'rstephe n' ,1) > 0; PROMPT PROMPT select score(1), searchfield from testtable2 where contains(searchfield,' stephen' ,1) > 0; select score(1), searchfield from testtable2 where contains(searchfield,'stephen ' ,1) > 0; == Here are the results: === Table created. 1 row created. 1 row created. Index created. select score(1), searchfield from testtable2 where contains(searchfield,'rstephen' ,1) > 0 SCORE(1) SEARCHFIELD -- -- 3 rstephenVb03R/o2Vi7Iwomigod/o/r/rstephen 3 gar001wuHkq2GP3o3O.rstephen/o/g/gar001 2 rows selected. select score(1), searchfield from testtable2 where contains(searchfield,'stephen' ,1) > 0 no rows selected === So, why does the first query work and not the second one? 'stephen' exists in the searchfield as well. Oracle Intermedia text is new to me, so any help would be appreciated, Thanks, Rick Stephenson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia Indexing
Hemant, The 8.1.6 docs (no change to this in the 8.1.7 addendum) say that only PDF 1.0, 1.1, and 1.2 formats are supported by the interMedia Text filters. We index plain text and HTML documents (about 3 million per month) and have had zero errors for the last two years. We're currently on 8.1.7.3.0 under Win2k. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Friday, April 26, 2002 1:18 AM To: Multiple recipients of list ORACLE-L Hi, We have an Oracle iFS installation and have enabled Intermedia. Some documents fail indexing with "Status 1" or "Status 2" errors. The documents are PDF (pdf 1.3), Excel, World and HTM documents. I do have a TAR open with Support. Just would like to know from the field how successful is Intermedia in indexing documents ? Are there any "gotchas" ? Oracle8i 8.1.7.3 on Solaris for iFS9.0.1 Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Intermedia question
yes, its possible. although, from my experience indexing a bfile takes a lot longer than indexing a blob... and why not try using IFS for this? [EMAIL PROTECTED] wrote: > Good day, > > I have an application that has many documents (Word, Excel, pdf, email etc) stored >on a Solaris file system. I want to be able to search the contents of those document. >Is it possible to create some tables in the database that has BFILE > columns that reference those documents outside the database and use InterMedia to do >searching? > > I am not familiar with LOBs and Intermedia, that's why I ask this basic question. > > Thanks > Long > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia question
Hi Maria, IFS would involve scanning the whole document whereas Intermedia allows for indexing the documents. -Original Message- Sent: 21 September 2001 10:40 To: Multiple recipients of list ORACLE-L yes, its possible. although, from my experience indexing a bfile takes a lot longer than indexing a blob... and why not try using IFS for this? [EMAIL PROTECTED] wrote: > Good day, > > I have an application that has many documents (Word, Excel, pdf, email etc) stored on a Solaris file system. I want to be able to search the contents of those document. Is it possible to create some tables in the database that has BFILE > columns that reference those documents outside the database and use InterMedia to do searching? > > I am not familiar with LOBs and Intermedia, that's why I ask this basic question. > > Thanks > Long > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia question
Thanks Maria and Martin for your answers. I prefer the Intermeida option than the IFS option since IFS requires a big server to run and relatively new, where Intermedia (formerly Context) has been there for a number of years. I would need to do some reading re. Intermedia and BFILE. Thanks Long -Original Message- Sent: Friday, 21 September 2001 10:45 PM To: Multiple recipients of list ORACLE-L Hi Maria, IFS would involve scanning the whole document whereas Intermedia allows for indexing the documents. -Original Message- Sent: 21 September 2001 10:40 To: Multiple recipients of list ORACLE-L yes, its possible. although, from my experience indexing a bfile takes a lot longer than indexing a blob... and why not try using IFS for this? [EMAIL PROTECTED] wrote: > Good day, > > I have an application that has many documents (Word, Excel, pdf, email etc) stored on a Solaris file system. I want to be able to search the contents of those document. Is it possible to create some tables in the database that has BFILE > columns that reference those documents outside the database and use InterMedia to do searching? > > I am not familiar with LOBs and Intermedia, that's why I ask this basic question. > > Thanks > Long > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Problems with Intermedia
Hi there !! Hi there, An application running the Intermedia process ctxhx is seen to b consuming an unusually high CPU time thus preventing other applications from running. Being very new to Intermedia I do not why this is happening. Can somebody help me on how to diagnose the problem of high CPU usage by ctxhx and correct it ?? Any help will be greatly appreciated. Thanks. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia search query
Dear DBA Gurus, I have a query for getting search results for a string like 100%. We are using a stop word in the preferences as % and setting the attribute as % in printjoins attribute in create preference. My Query is select * from myTable where contains (title, '100{%}') > 0. This returns the results properly. But if the query is select * from myTable where contains (title, '100 {%}') > 0, I am still getting the same results. (Note that there is a space after 100). Any idea to check this or how to give the String? Any help in this regard will be greatly appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
create interMedia index problem
Hi: I have this problem on our production server and I don't know too much about InterMedia stuff. We have oracle 8173 on Sun Solaris 2.8. [EMAIL PROTECTED]> desc DRUGDATA; Name Null?Type - IDNOT NULL NUMBER DRUGREPID NOT NULL NUMBER FIELD NOT NULL NUMBER TEXT VARCHAR2(4000) DRUGTERMID NUMBER DATATYPEIDNOT NULL NUMBER ADD_FILE NOT NULL VARCHAR2(32) ADD_DATE NOT NULL DATE DEL_FILE VARCHAR2(32) DEL_DATE DATE STATUSNOT NULL CHAR(1) ORDERBY NOT NULL NUMBER [EMAIL PROTECTED]> select count(*) from DRUGDATA; COUNT(*) -- 0 TABLESPACE_NAME USED-Kb ALLOC-KbUSED% SEGS >EXT >NEXTEXT --- --- -- - - DATA 3,000 1,048,576 .3 1 1 504 INDEXES 10,664,424 14,680,064 72.6 48011 693,080 PERFSTAT 105,728 2,097,1525.056 150 128 PROTEOME 164,872 1,048,576 15.75219 25,600 RBS5,131,360 8,388,608 61.2 6 8002,048 RESCTX43,832 6,803,456 .66628 504 RESDATA 34,470,408 46,137,344 74.7 361 2319 RESINDEX 41,046,376 69,206,016 59.3 300 1063 512,000 SYSTEM74,320 153,600 48.4 401 1151,120 TEMP 10,224,960 10,240,000 99.9 1 20455,000 YPD 12,769,224 16,777,216 76.1 249 # 292,976 TABLESPACE_NAME USED-Kb ALLOC-KbUSED% SEGS >EXT >NEXTEXT --- --- -- - - YPDCUST0 1,048,576 .0 0 00 Then I ran create index DRUGDATAINDEX_TEXT on DRUGDATA (TEXT) indextype is ctxsys.context parameters ('LEXER ctxsys.ISILEX WORDLIST ctxsys.ISIWORDLIST STOPLIST ctxsys.ISISTOP storage isistore memory 50M'); I got create index DRUGDATAINDEX_TEXT on DRUGDATA (TEXT) * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-2: interMedia Text error: DRG-50857: oracle error in drixtab.create_index_tables ORA-01658: unable to create INITIAL extent for segment in tablespace RESINDEX ORA-06512: at "CTXSYS.DRUE", line 126 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78 ORA-06512: at line 1 and I got from alert_log file: ORA-1652: unable to extend temp segment by 128000 in tablespace RESINDEX I did coalesce on all tablespace and added another 2G datafile on RESINDEX tablespace, I still got the same error. BTW, I could run the same sql on two other DEV instances without any problem. The RESINDEX ts on them are much more filled (like 90% full). Any idea what might be the problem? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Intermedia tag "<" problem
Hi, You will have to change your input data and replace the "<" with "<". This is one of the standard 5 XML entity references. Really you need to make sure that you have no double quotes, single quotes, less than , greater than or ampersands in your data and if you do replace then with the appropriate entity reference: & -> & " -> " ' -> ' < -> < > -> > Regards Pete -Original Message- Sent: 28 March 2003 14:34 To: Multiple recipients of list ORACLE-L Hi Gurus, We are working with Intermedia Text 8.1.6. We created a intermedia index on a search field. We also created 2 sections in this field. Table name : S01 Filed name : S01_search Sections name : SY,MAN Here is an example of data in this field: CyanePhibro Energy * This example works fine. But we have a problem when there is a "<" character in the data. Intermedia thinks it's a new tag and tries to find a section but it cannot. Exemple: Cyane < 10 Phibro Energy * Question : 1- Should we do something with the "<" in our data ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Intermedia tag "<" problem
Thank you Peter and Jan. Luc --- "Hitchman, Peter" <[EMAIL PROTECTED]> wrote: > Hi, > You will have to change your input data and replace > the "<" with "<". > This is one of the standard 5 XML entity references. > Really you need to make > sure that you have no double quotes, single quotes, > less than , greater than > or ampersands in your data and if you do replace > then with the appropriate > entity reference: > > & -> & > " -> " > ' -> ' > < -> < > > -> > > > Regards > > Pete > > -Original Message- > Sent: 28 March 2003 14:34 > To: Multiple recipients of list ORACLE-L > > > Hi Gurus, > > We are working with Intermedia Text 8.1.6. > We created a intermedia index on a search field. We > also created 2 sections in this field. > > Table name : S01 > Filed name : S01_search > Sections name : SY,MAN > > Here is an example of data in this field: > CyanePhibro Energy * > This example works fine. > > But we have a problem when there is a "<" character > in > the data. > > Intermedia thinks it's a new tag and tries to find a > section but it cannot. > Exemple: > Cyane < 10 Phibro Energy * > > Question : > 1- Should we do something with the "<" in our data ? > > TIA > Luc > > > > = > Luc Demanche > [EMAIL PROTECTED] > > __ > Do you Yahoo!? > Yahoo! Platinum - Watch CBS' NCAA March Madness, > live on your desktop! > http://platinum.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Luc Demanche > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (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). > > > ** > This email and any files transmitted with it are > confidential and > intended solely for the use of the individual or > entity to whom they > are addressed. If you have received this email in > error please notify > the system manager. > > This footnote also confirms that this email message > has been swept by > MIMEsweeper for the presence of computer viruses. > > www.mimesweeper.com > ** > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Hitchman, Peter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (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). > = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Update Intermedia Index Realtime
Hi list! I have a db which using intermedia index. Can I update this index real time? I am running 9.0.0 on W2K Server. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen Nam Trung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
interMedia Textkey (DRG-10826)
All... I'm running Oracle 8.1.6 on Solaris 8. Will someone please help me understand the Textkey parameter in the ctx_doc.themes function? I am receiving a DRG-10826 error on: exec ctx_doc.themes('ctx_webdocs', 1, 'MYTHEMES', 1, full_themes => TRUE); The index is on a BLOB column that, for the moment, contains only textual data (not that it really matters, anyway). I don't understand the relation of the textkey to the table. TIA!! Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
interMedia Textkey (DRG-10826)
All... One more submission to see if there are any takers, then I'll stop nagging and keep looking... I'm running Oracle 8.1.6 on Solaris 8. Will someone please help me understand the Textkey parameter in the ctx_doc.themes function? I am receiving a DRG-10826 error on: exec ctx_doc.themes('ctx_webdocs', 1, 'MYTHEMES', 1, full_themes => TRUE); The index is on a BLOB column that, for the moment, contains only textual data (not that it really matters, anyway). I don't understand the relationship of the textkey to the table and/or index. Any help is greatly appreciated. TIA!! Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Oracle InterMedia/Blob,Clob
Hi Experts, Oracle interMedia enables Oracle8i to manage image, audio, video in an integrated fashion with other enterprise information. This means that complex multimedia data can be stored, retrieved, and manipulated by Oracle8i in the same fashion as traditional relational data using data types ORDAudio, ORDImage and ORDVideo. Using JDeveloper i can quickly & easily build JSP applications using these data types for storing , retrieving and manipulating image, audio and video files. My questions is how can we achieve the same results with document formats which contain text like *.pdf , *.doc , *.ppt etc ??. I suspect we can use BLOB or CLOB data types to store them but then how the be retrieved and manipulated using web based applications developed using JDeveloper? Kindly recommend any web links or share u'r experience in handling document formats which contain text like *.pdf , *.doc , *.ppt stored in Blobs or Clobs and accessed using web applications. TIA '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Omar Khalid/IT/LotusCert/Pk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
817 Intermedia on AIX
Is there anyone else out there running version 8172 Intermedia on AIX 4.3? We recently upgraded a text database from 734 to 817 and started getting either ORA 3113 or ORA 600 [12700] errors on iMedia queries. Upgraded to 8172 because Oracle said it contained a patch for this bug, but the second business day after the upgrade, we're back to the ORA 600 [12700] error. One doc on Metalink says it may be caused by corrupted indexes, but analyze comes back clean. It also says it could be from heavy update & query activities against the same set of data. I suppose I could just tell them to stop doing that, but I was hoping for some other solution. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuan, Amy M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia Performance Benchmarks anyone ?
Hello all, Although I have installed Intermedia as part of my general DBA duties before I have not experienced any particular requirements on throughput rate or indexing. I need some information on being able to deal with large volumes of product data (e.g. 1 million products in a retail application) and be able to perform 'intelligent' searches against the metadata (things like typographical error matching, synonyms etc.) as well as the more usual parametric search (i.e. advanced search page with lots of metadata specific fields). Indexing time and max throughput are also of interest. Any data based on experience would be appreciated. Thanks Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Problems with Intermedia
Samir, interMedia Text, Audio, Image, Video? What version of Oracle? What platform? We need more info. We use interMedia Text heavily (Oracle 8.1.6 on Win2k) and I've never seen the ctxhx process. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Samir Sent: Monday, October 22, 2001 6:10 AM To: Multiple recipients of list ORACLE-L Hi there !! Hi there, An application running the Intermedia process ctxhx is seen to b consuming an unusually high CPU time thus preventing other applications from running. Being very new to Intermedia I do not why this is happening. Can somebody help me on how to diagnose the problem of high CPU usage by ctxhx and correct it ?? Any help will be greatly appreciated. Thanks. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Problems with Intermedia
Hi Jack, I am a bit out of my depth here. I configured the listener so that it can use the INSO filter by setting the ENVS=LD_LIBRARY_PATH=/usr/local/oracle/8.1.7/ctx/lib in the listener.ora. We r using Intermedia text on 8.1.7.0 on SunOS. When I tried to check the listener by executing the command SQL> exec ctx_adm.test_extproc; (by logging on as ctxsys user) I get the following error : ERROR at line 1: ORA-20000: interMedia Text error: ORA-06520: PL/SQL: Error loading external library ORA-06522: ld.so.1: extprocPLSExtProc: fatal: /usr/local/oracle/product/8.1.7xibibctxx8.so: open failed: No such file or directory ORA-06512: at "CTXSYS.DRUE", line 126 ORA-06512: at "CTXSYS.CTX_ADM", line 287 ORA-06512: at line 1 Could u please help me resolve this ?? Do I have to put in the LD_LIBRARY_PATH explicitly too and export it ?? Also, ctxhx is the user filter executable for the INSO filter. I killed that process since it was using up almost 95% of my CPU time. Any help would be greatly appreciated. Thanks and Regards, Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 22 October 2001 17:25 To: Multiple recipients of list ORACLE-L Samir, interMedia Text, Audio, Image, Video? What version of Oracle? What platform? We need more info. We use interMedia Text heavily (Oracle 8.1.6 on Win2k) and I've never seen the ctxhx process. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Samir Sent: Monday, October 22, 2001 6:10 AM To: Multiple recipients of list ORACLE-L Hi there !! Hi there, An application running the Intermedia process ctxhx is seen to b consuming an unusually high CPU time thus preventing other applications from running. Being very new to Intermedia I do not why this is happening. Can somebody help me on how to diagnose the problem of high CPU usage by ctxhx and correct it ?? Any help will be greatly appreciated. Thanks. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia violates own constraint.
Hi. I had some problems with getting Intermedia to work after patching to 8.1.7. I got a ORA-04045: errors during recompilation/revalidation of CTXSYS.CONTEXT ORA-29835: ODCIGETINTERFACES routine does not return required interface(s) When trying to create an index. Searched Metalink, and eventually found document 1327325 where the workaround is stated to be spool recompile1.sql select 'alter package '||owner||'.'||object_name||' compile;' from dba_objects where object_type='PACKAGE' and status='INVALID' and owner in('ORDSYS','CTXSYS'); spool off; @recompile1.sql I applied this, but when I try to create the index now, I get SQL> CREATE INDEX ccs_search_index ON ccs_search(content) INDEXTYPE IS ctxsys.context PARAMETERS('section group ccs_search_group'); 23 CREATE INDEX ccs_search_index * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-2: interMedia Text error: ORA-1: unique constraint (CTXSYS.DRC$IDX_COLSPEC) violated ORA-06512: at "CTXSYS.DRUE", line 122 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34 ORA-06512: at line 1 It seems to me, that intermedia tries to index into an existing table, and failes because it has lost track of it's own sequence? I'm just guessing here and could really use a few tips to get this thing working. Thanks, Morten -- Morten Primdahl Caput A/S Tel +45 70 12 24 42 [EMAIL PROTECTED]Nygade 6Fax +45 70 11 24 42 http://www.caput.com/ DK-1164 Kbh K -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morten Primdahl INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Oracle Intermedia Search Query
Dear DBA Gurus, I have the following records in Oracle 8.1.6 database (CLOB fields). idtitle 1 kid's 2 kid and teen 3 kid's 4 kid's and teens If I write a query as select * from site where contains(title,'kid''s') > 0 then it displays all the 4 records where are I want only records 1, 3 and 4 only. If I try with: select * from site where contains(title, 'kid||chr(39)||s') > 0 then it is returning error ORA - 29902. How do I write the query in order to return the correct result? Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia text table design
Dear DBA Gurus, I have given below the procedure as how we are creating the tables, preference and indexing for the same. Could you please check if there is any other preference need to be set for CLOB Datatypes which I missed? 1) To create category table. CREATE TABLE CATEGORY PK_CATEGORY_IDNUMBER NOT NULL, PARENT_CATEGORY NUMBER NOT NULL, NAME VARCHAR2 (1000) NOT NULL, DEPTH VARCHAR2 (4000) NOT NULL, STATUSNUMBER NOT NULL, UPDATED_DATETIME DATE, PRIMARY KEY ( PK_CATEGORY_ID ) ); 2. To create site table. CREATE TABLE SITE PK_SITE_ID NUMBER NOT NULL, FK_CATEGORY NUMBER NOT NULL, TITLECLOB, URL VARCHAR2 (4000) NOT NULL, DESCRIPTION CLOB, STATUS NUMBER NOT NULL, PAGE_HITSNUMBER NOT NULL, EDITOR_CHOICE VARCHAR2 (10), PRIMARY KEY ( PK_SITE_ID )); ALTER TABLE SITE ADD CONSTRAINT FKSITE FOREIGN KEY (FK_CATEGORY) REFERENCES VCPLNEW.CATEGORY (PK_CATEGORY_ID) ; 3) Creating an index after inserting the data(Datebase Updation) in both the tables. a) Execute this script to create a preference. begin ctx_ddl.create_preference('sitelexer', 'BASIC_LEXER'); ctx_ddl.set_attribute('sitelexer', 'printjoins', '_-'); ctx_ddl.set_attribute('sitelexer', 'endjoins', '%'); ctx_ddl.set_attribute ( 'sitelexer', 'index_text', 'YES'); ctx_ddl.set_attribute ( 'sitelexer', 'mixed_case', 'NO'); end; b) Execute this script to create an indexes. CREATE INDEX site1descidx ON site(description) indextype is ctxsys.context parameters ( 'LEXER sitelexer' ); CREATE INDEX site2titleidex ON site(title) indextype is ctxsys.context parameters ( 'LEXER sitelexer' ); TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
intermedia text and dbms_job problem
OK, I know I must be doing something wrong, would somebody please point out what it is? I would like to set up a job to sync an intermedia text index. Here is my job: SQL> select what from all_jobs where job = 2; WHAT - ctx_ddl.sync_index ( 'ctx_xml_text' ); I can execute the procedute from the command line like so: SQL> execute ctx_ddl.sync_index ( 'ctx_xml_text' ); PL/SQL procedure successfully completed. But the job itself fails: SQL> execute dbms_job.run ( 2 ); BEGIN dbms_job.run ( 2 ); END; * ERROR at line 1: ORA-12011: execution of 1 jobs failed ORA-06512: at "SYS.DBMS_IJOB", line 405 ORA-06512: at "SYS.DBMS_JOB", line 267 ORA-06512: at line 1 in my init.ora I have: job_queue_processes = 4 job_queue_interval = 60 I am in the ctxapp role, and ctxsys has granted me execute on ctx_ddl. The only other job works just fine. OS=Solaris, Version=8.1.7 What the heck is going on? Thanks in advance, Bill Bill Tantzen University of Minnesota Libraries [EMAIL PROTECTED] 612-626-9949 (office) 612-250-6125 (cell) I guess the man's a genius, but what a dirty mind he has, hasn't he? -- Nora Joyce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Tantzen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: create interMedia index problem
Guang, Is your RESINDEX tablespace a Locally-Managed Tablespace with Uniform Extents of less than 3 database blocks? If so, that's your problem. InterMedia indexes consist of some LOB segments and those require extents of at least 3 database blocks - at least in 8i. If not, I don't know. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Guang Mei <[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L Sent by: <[EMAIL PROTECTED]> [EMAIL PROTECTED] cc: Subject: create interMedia index problem 03/27/2003 10:53 PM Please respond to ORACLE-L Hi: I have this problem on our production server and I don't know too much about InterMedia stuff. We have oracle 8173 on Sun Solaris 2.8. [EMAIL PROTECTED]> desc DRUGDATA; Name Null?Type - IDNOT NULL NUMBER DRUGREPID NOT NULL NUMBER FIELD NOT NULL NUMBER TEXT VARCHAR2(4000) DRUGTERMID NUMBER DATATYPEIDNOT NULL NUMBER ADD_FILE NOT NULL VARCHAR2(32) ADD_DATE NOT NULL DATE DEL_FILE VARCHAR2(32) DEL_DATE DATE STATUSNOT NULL CHAR(1) ORDERBY NOT NULL NUMBER [EMAIL PROTECTED]> select count(*) from DRUGDATA; COUNT(*) -- 0 TABLESPACE_NAME USED-Kb ALLOC-KbUSED% SEGS >EXT >NEXTEXT --- --- -- - - DATA 3,000 1,048,576 .3 1 1 504 INDEXES 10,664,424 14,680,064 72.6 48011 693,080 PERFSTAT 105,728 2,097,1525.056 150 128 PROTEOME 164,872 1,048,576 15.75219 25,600 RBS5,131,360 8,388,608 61.2 6 8002,048 RESCTX43,832 6,803,456 .66628 504 RESDATA 34,470,408 46,137,344 74.7 361 2319 RESINDEX 41,046,376 69,206,016 59.3 300 1063 512,000 SYSTEM74,320 153,600 48.4 401 1151,120 TEMP 10,224,960 10,240,000 99.9 1 20455,000 YPD 12,769,224 16,777,216 76.1 249 # 292,976 TABLESPACE_NAME USED-Kb ALLOC-KbUSED% SEGS >EXT >NEXTEXT --- --- -- - - YPDCUST0 1,048,576 .0 0 00 Then I ran create index DRUGDATAINDEX_TEXT on DRUGDATA (TEXT) indextype is ctxsys.context parameters ('LEXER ctxsys.ISILEX WORDLIST ctxsys.ISIWORDLIST STOPLIST ctxsys.ISISTOP storage isistore memory 50M'); I got create index DRUGDATAINDEX_TEXT on DRUGDATA (TEXT) * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-2: interMedia Text error: DRG-50857: oracle error in drixtab.create_index_tables ORA-01658: unable to create INITIAL extent for segment in tablespace RESINDEX ORA-06512: at "CTXSYS.DRUE", line 126 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78 ORA-06512: at line 1 and I got from alert_log file: ORA-1652: unable to extend temp segment by 128000 in tablespace RESINDEX I did coalesce on all t
Re: create interMedia index problem
Hi: The problem has been fixed. It turned out that we have very big storage clause for "isistore". All these Intermedia tables will be created when InterMedia index gets created. So it would try to allocate six 1000M initial extents. And we don't have that many empty block in RESINDEX tablespace. begin ctx_ddl.create_preference('isistore', 'BASIC_STORAGE'); ctx_ddl.set_attribute('isistore', 'I_TABLE_CLAUSE', 'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)'); ctx_ddl.set_attribute('isistore', 'K_TABLE_CLAUSE', 'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)'); ctx_ddl.set_attribute('isistore', 'R_TABLE_CLAUSE', 'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)'); ctx_ddl.set_attribute('isistore', 'N_TABLE_CLAUSE', 'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)'); ctx_ddl.set_attribute('isistore', 'I_INDEX_CLAUSE', 'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)'); ctx_ddl.set_attribute('isistore', 'P_TABLE_CLAUSE', 'tablespace RESINDEX storage (initial 1000M next 500M pctincrease 0)'); end; So I run the following to reduce the initial setting to 100M. After that everything is OK. begin -- ctx_ddl.create_preference('isistore', 'BASIC_STORAGE'); ctx_ddl.set_attribute('isistore', 'I_TABLE_CLAUSE', 'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)'); ctx_ddl.set_attribute('isistore', 'K_TABLE_CLAUSE', 'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)'); ctx_ddl.set_attribute('isistore', 'R_TABLE_CLAUSE', 'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)'); ctx_ddl.set_attribute('isistore', 'N_TABLE_CLAUSE', 'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)'); ctx_ddl.set_attribute('isistore', 'I_INDEX_CLAUSE', 'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)'); ctx_ddl.set_attribute('isistore', 'P_TABLE_CLAUSE', 'tablespace RESINDEX storage (initial 100M next 100M pctincrease 0)'); end; Guang -Original Message- [EMAIL PROTECTED] Sent: Friday, March 28, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Guang, Is your RESINDEX tablespace a Locally-Managed Tablespace with Uniform Extents of less than 3 database blocks? If so, that's your problem. InterMedia indexes consist of some LOB segments and those require extents of at least 3 database blocks - at least in 8i. If not, I don't know. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Guang Mei <[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L Sent by: <[EMAIL PROTECTED]> [EMAIL PROTECTED] cc: Subject: create interMedia index problem 03/27/2003 10:53 PM Please respond to ORACLE-L Hi: I have this problem on our production server and I don't know too much about InterMedia stuff. We have oracle 8173 on Sun Solaris 2.8. [EMAIL PROTECTED]> desc DRUGDATA; Name Null?Type - IDNOT NULL NUMBER DRUGREPID NOT NULL NUMBER FIELD NOT NULL NUMBER TEXT VARCHAR2(4000) DRUGTERMID NUMBER DATATYPEIDNOT NULL NUMBER ADD_FILE NOT NULL VARCHAR2(32) ADD_DATE NOT NULL DATE DEL_FILE VARCHAR2(32) DEL_DATE DATE STATUSNOT NULL CHAR(1) ORDERBY NOT NULL NUMBER [EMAIL PROTECTED]> select count(*) from DRUGDATA; COUNT(*) -- 0 TABLESPACE_NAME USED-Kb ALLOC-KbUSED% SEGS >EXT >NEXTEXT --- --- -- - - DATA 3,000 1,048,576 .3 1 1 504 INDEXES 10,664,424 14,680,064 72.6 48011 693,080 PERFSTAT 105,728 2,097,1525.05
Re: interMedia Textkey (DRG-10826)
All... STUPID, STUPID, STUPID!!! > Will someone please help me understand the Textkey parameter in the > ctx_doc.themes function? I am receiving a DRG-10826 error on: I withdraw my question -- I was looking at it MANY layers too deeply, and absolutely overlooked the braindead obvious. Sorry for the noise. Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Oracle InterMedia/Blob,Clob
The interMedia Text option certainly handles PDF, DOC & PPT. I believe JDeveloper is pretty well integrated with interMedia Text, so I suspect that it does what you're looking for. At 06:33 AM 9/25/2002, Omar Khalid/IT/LotusCert/Pk wrote: >Hi Experts, > >Oracle interMedia enables Oracle8i to manage image, audio, video >in an integrated fashion with other enterprise information. This >means that complex multimedia data can be stored, retrieved, >and manipulated by Oracle8i in the same fashion as traditional >relational data using data types ORDAudio, ORDImage and ORDVideo. >Using JDeveloper i can quickly & easily build JSP applications using these >data >types for storing , retrieving and manipulating image, audio and video >files. > >My questions is how can we achieve the same results with document formats >which contain text like *.pdf , *.doc , *.ppt etc ??. I suspect we can use >BLOB >or CLOB data types to store them but then how the be retrieved and >manipulated >using web based applications developed using JDeveloper? Kindly recommend >any >web links or share u'r experience in handling document formats which >contain >text like *.pdf , *.doc , *.ppt stored in Blobs or Clobs and accessed using >web applications. > >TIA > >'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' >Omar Khalid >Software Engineer >LMK Resources >Voice: 111-101-101*780 >Mobile: 0333-510-4465 >Web: www.lmkr.com >'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Omar Khalid/IT/LotusCert/Pk > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (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). Justin Cave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
intermedia - create and drop synonyms
Hi, I'm having problems with intermedia for synonyms in the thesaurus. Here a list of request that I execute and that order and their results: select ctx_thes.SYN('disease','gdermthes_md') from DUAL; {DISEASE}|{SICKNESS}|{MALADIE1} execute CTX_THES.DROP_RELATION('gdermthes_md','DISEASE','SYN','maladie1'); select ctx_thes.SYN('disease','gdermthes_md') from DUAL; {DISEASE} execute CTX_THES.CREATE_RELATION('gdermthes_md','maladie1','SYN','DISEASE'); select ctx_thes.SYN('disease','gdermthes_md') from DUAL; {DISEASE}|{SICKNESS}|{MALADIE1} The problem is that when I remove the relationship between disease and maladie1, I lose sickness as well in my synonyms for disease. On the other hand, if I reverse the order of my parameters in the drop_relation like that: execute CTX_THES.DROP_RELATION('gdermthes_md','maladie1','SYN','disease'); If works correctly. That creates a problem for me because for every other relationship types, it's always source term first and target term second. I'm trying to write generic code to handle those tasks and I don't want to do a special case for synonyms. Thanks for any help.
Re: 817 Intermedia on AIX
You may want to connect as ctxsys and query the user_libraries view to make sure the library paths are pointing to your new 8.1.7 Oracle_home. Just a thought. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 817 Intermedia on AIX
Yes, I've done that. Oracle is telling me that doing dml and running iMedia queries simultaneously is causing a consistent read problem and I should not use ctxsrv to resync the index. They're telling me to run sync_index as a scheduled job because ctxsrv is going away. Glad to see Oracle is moving forward. -Original Message- Sent: Wednesday, August 29, 2001 10:21 AM To: Multiple recipients of list ORACLE-L You may want to connect as ctxsys and query the user_libraries view to make sure the library paths are pointing to your new 8.1.7 Oracle_home. Just a thought. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuan, Amy M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 817 Intermedia on AIX
Title: RE: 817 Intermedia on AIX Also - I ran into this problem on hp/ux: you may have to create the library hard coded with the oracle home path. REferencing $ORACLE_HOME (in user_libraries) did not work. Lisa Koivu The Bootylicious DBA Ft. Lauderdale, FL, USA -Original Message- From: Mike J Kurth [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Subject: Re: 817 Intermedia on AIX You may want to connect as ctxsys and query the user_libraries view to make sure the library paths are pointing to your new 8.1.7 Oracle_home. Just a thought. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 817 Intermedia on AIX
The Bootylicious DBA? I can't believe you went there. ;-) "Koivu, Lisa"To: Multiple recipients of list ORACLE-L field.com> cc: Sent by:Subject: RE: 817 Intermedia on AIX [EMAIL PROTECTED] 08/29/2001 12:57 PM Please respond to ORACLE-L Also - I ran into this problem on hp/ux: you may have to create the library hard coded with the oracle home path. REferencing $ORACLE_HOME (in user_libraries) did not work. Lisa Koivu The Bootylicious DBA Ft. Lauderdale, FL, USA -Original Message- From: Mike J Kurth [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Subject:Re: 817 Intermedia on AIX You may want to connect as ctxsys and query the user_libraries view to make sure the library paths are pointing to your new 8.1.7 Oracle_home. Just a thought. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 817 Intermedia on AIX
"The Bootylicious " "Gimme a PC and I'll Break It, Guaranteed" "The MONkey" Boy ! arn't we busy today. ROR mô¿ôm >>> [EMAIL PROTECTED] 08/29/01 01:57PM >>> Also - I ran into this problem on hp/ux: you may have to create the library hard coded with the oracle home path. REferencing $ORACLE_HOME (in user_libraries) did not work. Lisa Koivu The Bootylicious DBA Ft. Lauderdale, FL, USA > -Original Message- > From: Mike J Kurth [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 11:21 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: 817 Intermedia on AIX > > > You may want to connect as ctxsys and query the user_libraries view > to make sure the library paths are pointing to your new 8.1.7 Oracle_home. > Just a thought. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mike J Kurth > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
8.1.7.2.5 interMedia Text Slow Sync
We are experiencing very slow interMedia Text resyncs ( CTX_DDL.Sync_Index ) under 8.1.7.2.5 on Win2k Server. We upgraded from 8.1.6.0.0 to 8.1.7.2.5 earlier this month (both under Win2k Server) on essentially the same hardware. We used to see about 700-2000 CLOB documents per second indexed under 8.1.6, but now see only about 400-800. The low-high numbers relate to the size of the index being sync'd - low just before we roll out a monthly partition (total 2 million CLOBs), high just after (total 1 million CLOBs). Query performance is better under 8.1.7 - partly because I spread the DR$<>$I table across 3 drives. By the looks of the I/O pattern, I should spread DR$<>$X (the index on DR$<>$I table) across 2 or 3 drives as well. Anybody have any words of wisdom as to what I can do to speed things up? BTW, I'm curious at how 8.1.7 balances I/O. While it's writing to the DR$<>$X segment, it doesn't write to the online redo logs - it waits until it's reading from DR$<>$X segment before it writes to the redo logs. I wonder why it doesn't do the writes to redo in parallel with the writes to DR$<>$X. Thanks. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Moving table with interMedia datatype
Title: Moving table with interMedia datatype Hi - I have a table that contains 1 column with an interMedia datatype (ordsys.ordimage) and a blob column. I want to move the data from the table in our test server to our production server. I don't think an exp and imp will work on these datatypes. Does anyone know how I can accomplish this? Thanks in advance, Lisa
RE: Intermedia Performance Benchmarks anyone ?
Title: RE: Intermedia Performance Benchmarks anyone ? Hi Martin, I've had to implement intermedia in the past. with 1 million records intermedia will do the job in an acceptable amount of time. However, when testing it I found that the more advanced features I used (fuzzy, etc.) the worse performance became. It works well if you are doing a straightforward search. I also found there were problems with creating the library on HP/UX (part of the install). I had to create it manually. There are also tricks for indexing more than one column in one index. The documentation says you can't, but it can be done. I know there are people on the list that have done this. I didn't run any formal benchmarks. We had indexed ~6million records on long fields (like description) and performance was directly related to how selective the keywords were. Indexing time - If I remember right, creating one index on one of these description columns ran in ~2 hours. I also batched my updates. (I didn't run ctxsrv) The index ended up being ~1.5GB. Hope this helps and let me know if you have any other questions, I'll try and answer them. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Martin Kendall [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Intermedia Performance Benchmarks anyone ? Hello all, Although I have installed Intermedia as part of my general DBA duties before I have not experienced any particular requirements on throughput rate or indexing. I need some information on being able to deal with large volumes of product data (e.g. 1 million products in a retail application) and be able to perform 'intelligent' searches against the metadata (things like typographical error matching, synonyms etc.) as well as the more usual parametric search (i.e. advanced search page with lots of metadata specific fields). Indexing time and max throughput are also of interest. Any data based on experience would be appreciated. Thanks Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia Performance Benchmarks anyone ?
Martin, We use interMedia Text to index and query up to about 10-15 million CLOB documents (up to 5KB each). We're on 8.1.6.0.0 under Win2k - 2 550MHz CPUs, 2GB RAM, 18 36GB drives. Because a domain index cannot be partitioned, we have the documents spread across 5 tables (on 6 drives). One is a 2 partition table (each partition on its own drive) containing the current two months of docs, the other 4 hold the 4 prior months' docs. We can query the entire 6 months of docs via a Union View on them - even Contains() queries work fine on this view. When we add a new month's partition, the prior month's partition gets turned into a table (segment exchange). The interMedia Text indexes on the partitioned table and the new prior month are rebuilt. Lately we've been getting about 3.5 million docs/month and the index rebuild takes about 7 hours - that's 7 hrs. for the index on the prior month and 7 more hours for the index on the partitioned table, which only contains one month of docs at that point. Since we're adding docs every day, we sync the interMedia index every morning. Last night we added about 200,000 docs and it took about 3 hours for the index to resync. We don't use ctxsrv, but use CTX_DDL.Sync_Index. When we get over about 4.5 million docs in a table, the resync really slows down. The in-memory part still happens at about 150 docs/sec, but when interMedia writes to disk it slows down a bunch. What took 3 hours today will take 10 hours in a couple of weeks. That's why I plan on spreading the DR$<>$I segment across multiple drives by spreading the datafiles of its tablespace across those drives. BTW, that brings up some performance points - be sure you cache the DR$<>$R segment (use CACHE not CACHE READS, due to bugs in Oracle): Alter Table DR$$R Modify LOB (Data) (Cache) ; Also ensure that your LOBs are out-of-line and stored in their own segment(s) on drive(s) separate from the "regular" data. Make sure that your I_TABLE_CLAUSE, R_TABLE_CLAUSE, and I_INDEX_CLAUSE all specify tablespaces on their own drives to spread the I/O out even further. We're getting 2GB more RAM on a new server, so I plan on caching the 900MB DR$<>$X segment, which is the index on the DR$<>$I token table. I've learned a lot about how interMedia Text processes different kinds of queries by watching disk I/O on Win2k's Performance Monitor while I issue various "flavors". Our folks use lots of complex query terms with heavy use of the Stemmer. I've gotten them to switch from using tons of ORs to using the Equivalence operator and we're getting much better results using NEAR than simple ANDs. Performance is very good, with CONTAINS queries returning results in less than a second for terms that are rare in the docs, up to a minute for terms that are common in lots (e.g. hundreds of thousands) of docs. If you're going to do synonym searches, you'd better start looking for a good thesaurus - the one Oracle ships is pretty limited. We've not found a good one for the technical lingo our docs contain, so we don't do ABOUT queries at this time. Get familiar with CTX_Query.Explain, it will help you understand things like what the Stemmer *really* does and how complex queries are parsed. Hope this helps. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message----- Kendall Sent: Thursday, October 04, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Hello all, Although I have installed Intermedia as part of my general DBA duties before I have not experienced any particular requirements on throughput rate or indexing. I need some information on being able to deal with large volumes of product data (e.g. 1 million products in a retail application) and be able to perform 'intelligent' searches against the metadata (things like typographical error matching, synonyms etc.) as well as the more usual parametric search (i.e. advanced search page with lots of metadata specific fields). Indexing time and max throughput are also of interest. Any data based on experience would be appreciated. Thanks Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia Performance Benchmarks anyone ?
*excellent* post. thanks. Anyone out there put the indexes and tables on solid state disk? They have ssd up to about 10G and higher, I hearjust curious, not trying to invoke a global listserv discussion on how it "can't work" or "wouldn't be worth it, especially on microsoft platforms", etc. It would be neat to hear about an InterMedia indexing miracle. This really neat tool just sounds WAAY to slow to scale at this point, which answers a pet question of mine. (Something like "Why do services like 'Ask Jeeves' suck so hard?") In Love and Peas, etc. -Original Message- Sent: Thursday, October 04, 2001 5:47 PM To: Multiple recipients of list ORACLE-L Martin, We use interMedia Text to index and query up to about 10-15 million CLOB documents (up to 5KB each). We're on 8.1.6.0.0 under Win2k - 2 550MHz CPUs, 2GB RAM, 18 36GB drives. Because a domain index cannot be partitioned, we have the documents spread across 5 tables (on 6 drives). One is a 2 partition table (each partition on its own drive) containing the current two months of docs, the other 4 hold the 4 prior months' docs. We can query the entire 6 months of docs via a Union View on them - even Contains() queries work fine on this view. When we add a new month's partition, the prior month's partition gets turned into a table (segment exchange). The interMedia Text indexes on the partitioned table and the new prior month are rebuilt. Lately we've been getting about 3.5 million docs/month and the index rebuild takes about 7 hours - that's 7 hrs. for the index on the prior month and 7 more hours for the index on the partitioned table, which only contains one month of docs at that point. Since we're adding docs every day, we sync the interMedia index every morning. Last night we added about 200,000 docs and it took about 3 hours for the index to resync. We don't use ctxsrv, but use CTX_DDL.Sync_Index. When we get over about 4.5 million docs in a table, the resync really slows down. The in-memory part still happens at about 150 docs/sec, but when interMedia writes to disk it slows down a bunch. What took 3 hours today will take 10 hours in a couple of weeks. That's why I plan on spreading the DR$<>$I segment across multiple drives by spreading the datafiles of its tablespace across those drives. BTW, that brings up some performance points - be sure you cache the DR$<>$R segment (use CACHE not CACHE READS, due to bugs in Oracle): Alter Table DR$$R Modify LOB (Data) (Cache) ; Also ensure that your LOBs are out-of-line and stored in their own segment(s) on drive(s) separate from the "regular" data. Make sure that your I_TABLE_CLAUSE, R_TABLE_CLAUSE, and I_INDEX_CLAUSE all specify tablespaces on their own drives to spread the I/O out even further. We're getting 2GB more RAM on a new server, so I plan on caching the 900MB DR$<>$X segment, which is the index on the DR$<>$I token table. I've learned a lot about how interMedia Text processes different kinds of queries by watching disk I/O on Win2k's Performance Monitor while I issue various "flavors". Our folks use lots of complex query terms with heavy use of the Stemmer. I've gotten them to switch from using tons of ORs to using the Equivalence operator and we're getting much better results using NEAR than simple ANDs. Performance is very good, with CONTAINS queries returning results in less than a second for terms that are rare in the docs, up to a minute for terms that are common in lots (e.g. hundreds of thousands) of docs. If you're going to do synonym searches, you'd better start looking for a good thesaurus - the one Oracle ships is pretty limited. We've not found a good one for the technical lingo our docs contain, so we don't do ABOUT queries at this time. Get familiar with CTX_Query.Explain, it will help you understand things like what the Stemmer *really* does and how complex queries are parsed. Hope this helps. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Kendall Sent: Thursday, October 04, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Hello all, Although I have installed Intermedia as part of my general DBA duties before I have not experienced any particular requirements on throughput rate or indexing. I need some information on being able to deal with large volumes of product data (e.g. 1 million products in a retail application) and be able to perform 'intelligent' searches against the metadata (things like typographical error matching, synonyms etc.) as well as the more usual parametric search (i.e. advanced search page with lots of metadata specific fields). Inde
RE: Intermedia Performance Benchmarks anyone ?
Ross, I disagree that interMedia Text is "way too slow to scale". Our experience has convinced us that I/O bottlenecks are the main performance killers with large interMedia Text indexes. The problem is that it takes some experience to find out how this "special" kind of index is structured (6 or 8 separate table and index segments per "index") and how it behaves. As usual, the Oracle docs are pitifully inadequate - you've gotta search through TechNet and MetaLink for details and bug workarounds (like CACHE instead of CACHE READS for DR$<>$R). Caching the DR$<>$R segment helped immensely and I can see that when pieces of the DR$<>$X index are cached, queries with terms in those pieces are lightening fast. I am betting that when I spread the DR$<>$I table across multiple drives, instead of the single drive ours is currently on, we'll see much better performance of NEAR queries (which depend on the word position info. there), as well as faster index resyncs. In 9i Domain Indexes become partitionable, so I'm looking forward (in about a year - experiences with 6.0, 7.0, 8.0 and 8.1.5 have made me wary) to putting our 6 (or more) months of docs into one partitoned table. There may be other I/O distributing kinds of enhancements by then, as well. For sure I'll have explored every trick I can think of! ;-) With more drives and a bit more RAM, I think we can handle 10 million docs per month (60 million total online), even on our lil' ol' Win2k box. That's just x3 to x4 of what we do now. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Thursday, October 04, 2001 5:36 PM To: Multiple recipients of list ORACLE-L *excellent* post. thanks. Anyone out there put the indexes and tables on solid state disk? They have ssd up to about 10G and higher, I hearjust curious, not trying to invoke a global listserv discussion on how it "can't work" or "wouldn't be worth it, especially on microsoft platforms", etc. It would be neat to hear about an InterMedia indexing miracle. This really neat tool just sounds WAAY to slow to scale at this point, which answers a pet question of mine. (Something like "Why do services like 'Ask Jeeves' suck so hard?") In Love and Peas, etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia Performance Benchmarks anyone ?
I looked into SSD, they are like $15-17k / gb. Very expensive. And with Oracle buffering, I would expect the performance wouldn't be huge. There were some solutions that were like $2500 for a 1 gb, but they were not sharable between machines in a cluster. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/4/01 6:35 PM *excellent* post. thanks. Anyone out there put the indexes and tables on solid state disk? They have ssd up to about 10G and higher, I hearjust curious, not trying to invoke a global listserv discussion on how it "can't work" or "wouldn't be worth it, especially on microsoft platforms", etc. It would be neat to hear about an InterMedia indexing miracle. This really neat tool just sounds WAAY to slow to scale at this point, which answers a pet question of mine. (Something like "Why do services like 'Ask Jeeves' suck so hard?") In Love and Peas, etc. -Original Message- Sent: Thursday, October 04, 2001 5:47 PM To: Multiple recipients of list ORACLE-L Martin, We use interMedia Text to index and query up to about 10-15 million CLOB documents (up to 5KB each). We're on 8.1.6.0.0 under Win2k - 2 550MHz CPUs, 2GB RAM, 18 36GB drives. Because a domain index cannot be partitioned, we have the documents spread across 5 tables (on 6 drives). One is a 2 partition table (each partition on its own drive) containing the current two months of docs, the other 4 hold the 4 prior months' docs. We can query the entire 6 months of docs via a Union View on them - even Contains() queries work fine on this view. When we add a new month's partition, the prior month's partition gets turned into a table (segment exchange). The interMedia Text indexes on the partitioned table and the new prior month are rebuilt. Lately we've been getting about 3.5 million docs/month and the index rebuild takes about 7 hours - that's 7 hrs. for the index on the prior month and 7 more hours for the index on the partitioned table, which only contains one month of docs at that point. Since we're adding docs every day, we sync the interMedia index every morning. Last night we added about 200,000 docs and it took about 3 hours for the index to resync. We don't use ctxsrv, but use CTX_DDL.Sync_Index. When we get over about 4.5 million docs in a table, the resync really slows down. The in-memory part still happens at about 150 docs/sec, but when interMedia writes to disk it slows down a bunch. What took 3 hours today will take 10 hours in a couple of weeks. That's why I plan on spreading the DR$<>$I segment across multiple drives by spreading the datafiles of its tablespace across those drives. BTW, that brings up some performance points - be sure you cache the DR$<>$R segment (use CACHE not CACHE READS, due to bugs in Oracle): Alter Table DR$$R Modify LOB (Data) (Cache) ; Also ensure that your LOBs are out-of-line and stored in their own segment(s) on drive(s) separate from the "regular" data. Make sure that your I_TABLE_CLAUSE, R_TABLE_CLAUSE, and I_INDEX_CLAUSE all specify tablespaces on their own drives to spread the I/O out even further. We're getting 2GB more RAM on a new server, so I plan on caching the 900MB DR$<>$X segment, which is the index on the DR$<>$I token table. I've learned a lot about how interMedia Text processes different kinds of queries by watching disk I/O on Win2k's Performance Monitor while I issue various "flavors". Our folks use lots of complex query terms with heavy use of the Stemmer. I've gotten them to switch from using tons of ORs to using the Equivalence operator and we're getting much better results using NEAR than simple ANDs. Performance is very good, with CONTAINS queries returning results in less than a second for terms that are rare in the docs, up to a minute for terms that are common in lots (e.g. hundreds of thousands) of docs. If you're going to do synonym searches, you'd better start looking for a good thesaurus - the one Oracle ships is pretty limited. We've not found a good one for the technical lingo our docs contain, so we don't do ABOUT queries at this time. Get familiar with CTX_Query.Explain, it will help you understand things like what the Stemmer *really* does and how complex queries are parsed. Hope this helps. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Kendall Sent: Thursday, October 04, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Hello all, Although I have installed Intermedia as part of my general DBA duties before I have not experienced any particular requirements on throughput rate or indexing. I need some informati
RE: Intermedia Performance Benchmarks anyone ?
Jack, Thanks for your time on this. Most revealing and useful for what I have ahead of me Kind regards from the UK. Martin -Original Message- Sent: 04 October 2001 22:47 To: Multiple recipients of list ORACLE-L Martin, We use interMedia Text to index and query up to about 10-15 million CLOB documents (up to 5KB each). We're on 8.1.6.0.0 under Win2k - 2 550MHz CPUs, 2GB RAM, 18 36GB drives. Because a domain index cannot be partitioned, we have the documents spread across 5 tables (on 6 drives). One is a 2 partition table (each partition on its own drive) containing the current two months of docs, the other 4 hold the 4 prior months' docs. We can query the entire 6 months of docs via a Union View on them - even Contains() queries work fine on this view. When we add a new month's partition, the prior month's partition gets turned into a table (segment exchange). The interMedia Text indexes on the partitioned table and the new prior month are rebuilt. Lately we've been getting about 3.5 million docs/month and the index rebuild takes about 7 hours - that's 7 hrs. for the index on the prior month and 7 more hours for the index on the partitioned table, which only contains one month of docs at that point. Since we're adding docs every day, we sync the interMedia index every morning. Last night we added about 200,000 docs and it took about 3 hours for the index to resync. We don't use ctxsrv, but use CTX_DDL.Sync_Index. When we get over about 4.5 million docs in a table, the resync really slows down. The in-memory part still happens at about 150 docs/sec, but when interMedia writes to disk it slows down a bunch. What took 3 hours today will take 10 hours in a couple of weeks. That's why I plan on spreading the DR$<>$I segment across multiple drives by spreading the datafiles of its tablespace across those drives. BTW, that brings up some performance points - be sure you cache the DR$<>$R segment (use CACHE not CACHE READS, due to bugs in Oracle): Alter Table DR$$R Modify LOB (Data) (Cache) ; Also ensure that your LOBs are out-of-line and stored in their own segment(s) on drive(s) separate from the "regular" data. Make sure that your I_TABLE_CLAUSE, R_TABLE_CLAUSE, and I_INDEX_CLAUSE all specify tablespaces on their own drives to spread the I/O out even further. We're getting 2GB more RAM on a new server, so I plan on caching the 900MB DR$<>$X segment, which is the index on the DR$<>$I token table. I've learned a lot about how interMedia Text processes different kinds of queries by watching disk I/O on Win2k's Performance Monitor while I issue various "flavors". Our folks use lots of complex query terms with heavy use of the Stemmer. I've gotten them to switch from using tons of ORs to using the Equivalence operator and we're getting much better results using NEAR than simple ANDs. Performance is very good, with CONTAINS queries returning results in less than a second for terms that are rare in the docs, up to a minute for terms that are common in lots (e.g. hundreds of thousands) of docs. If you're going to do synonym searches, you'd better start looking for a good thesaurus - the one Oracle ships is pretty limited. We've not found a good one for the technical lingo our docs contain, so we don't do ABOUT queries at this time. Get familiar with CTX_Query.Explain, it will help you understand things like what the Stemmer *really* does and how complex queries are parsed. Hope this helps. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message----- Kendall Sent: Thursday, October 04, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Hello all, Although I have installed Intermedia as part of my general DBA duties before I have not experienced any particular requirements on throughput rate or indexing. I need some information on being able to deal with large volumes of product data (e.g. 1 million products in a retail application) and be able to perform 'intelligent' searches against the metadata (things like typographical error matching, synonyms etc.) as well as the more usual parametric search (i.e. advanced search page with lots of metadata specific fields). Indexing time and max throughput are also of interest. Any data based on experience would be appreciated. Thanks Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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-M
RE: Intermedia Performance Benchmarks anyone ?
Excellent doc. I just wonder if there are only cache related bugs on using interMedia. Mario Alberto Ramos >>> [EMAIL PROTECTED] 04/10/01 16:47 >>> Martin, We use interMedia Text to index and query up to about 10-15 million CLOB documents (up to 5KB each). We're on 8.1.6.0.0 under Win2k - 2 550MHz CPUs, 2GB RAM, 18 36GB drives. Because a domain index cannot be partitioned, we have the documents spread across 5 tables (on 6 drives). One is a 2 partition table (each partition on its own drive) containing the current two months of docs, the other 4 hold the 4 prior months' docs. We can query the entire 6 months of docs via a Union View on them - even Contains() queries work fine on this view. When we add a new month's partition, the prior month's partition gets turned into a table (segment exchange). The interMedia Text indexes on the partitioned table and the new prior month are rebuilt. Lately we've been getting about 3.5 million docs/month and the index rebuild takes about 7 hours - that's 7 hrs. for the index on the prior month and 7 more hours for the index on the partitioned table, which only contains one month of docs at that point. Since we're adding docs every day, we sync the interMedia index every morning. Last night we added about 200,000 docs and it took about 3 hours for the index to resync. We don't use ctxsrv, but use CTX_DDL.Sync_Index. When we get over about 4.5 million docs in a table, the resync really slows down. The in-memory part still happens at about 150 docs/sec, but when interMedia writes to disk it slows down a bunch. What took 3 hours today will take 10 hours in a couple of weeks. That's why I plan on spreading the DR$<>$I segment across multiple drives by spreading the datafiles of its tablespace across those drives. BTW, that brings up some performance points - be sure you cache the DR$<>$R segment (use CACHE not CACHE READS, due to bugs in Oracle): Alter Table DR$$R Modify LOB (Data) (Cache) ; Also ensure that your LOBs are out-of-line and stored in their own segment(s) on drive(s) separate from the "regular" data. Make sure that your I_TABLE_CLAUSE, R_TABLE_CLAUSE, and I_INDEX_CLAUSE all specify tablespaces on their own drives to spread the I/O out even further. We're getting 2GB more RAM on a new server, so I plan on caching the 900MB DR$<>$X segment, which is the index on the DR$<>$I token table. I've learned a lot about how interMedia Text processes different kinds of queries by watching disk I/O on Win2k's Performance Monitor while I issue various "flavors". Our folks use lots of complex query terms with heavy use of the Stemmer. I've gotten them to switch from using tons of ORs to using the Equivalence operator and we're getting much better results using NEAR than simple ANDs. Performance is very good, with CONTAINS queries returning results in less than a second for terms that are rare in the docs, up to a minute for terms that are common in lots (e.g. hundreds of thousands) of docs. If you're going to do synonym searches, you'd better start looking for a good thesaurus - the one Oracle ships is pretty limited. We've not found a good one for the technical lingo our docs contain, so we don't do ABOUT queries at this time. Get familiar with CTX_Query.Explain, it will help you understand things like what the Stemmer *really* does and how complex queries are parsed. Hope this helps. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Kendall Sent: Thursday, October 04, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Hello all, Although I have installed Intermedia as part of my general DBA duties before I have not experienced any particular requirements on throughput rate or indexing. I need some information on being able to deal with large volumes of product data (e.g. 1 million products in a retail application) and be able to perform 'intelligent' searches against the metadata (things like typographical error matching, synonyms etc.) as well as the more usual parametric search (i.e. advanced search page with lots of metadata specific fields). Indexing time and max throughput are also of interest. Any data based on experience would be appreciated. Thanks Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of
RE: Intermedia Performance Benchmarks anyone ?
Mario, Yes. In 8.1.6.0.0 on Win2k you can't use the SCORE() operator to return the actual document score produced by the CONTAINS operator when the query is executed against a Union View. That prevents us from ordering a result set by the Score() when we query our 6 Month View - a minor annoyance. However, SCORE() works just fine against interMedia Text indexed tables - either "regular" or partitioned. That's the only other real bug I can remember that we've run up against. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Friday, October 05, 2001 11:23 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Excellent doc. I just wonder if there are only cache related bugs on using interMedia. Mario Alberto Ramos -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia Domain index and tablespace
Dear list ! I'm creating an Intermedia domain index , and i want to build the index ( and related DR$... tables and indexes) in a specific tablespace , say IM_TBS . Although i can not specify the TABLESPACE attribute directly , when building a domain index , right ? So , how can i do it ? This is the create index statement i use CREATE INDEX mytab_idx1 ON mytab( bcontent ) INDEXTYPE IS ctxsys.context ;Thanks a lot in advance .
Intermedia Domain index and tablespace
Dear list ! I'm creating an Intermedia domain index , and i want to build the index ( and related DR$... tables and indexes) in a specific tablespace , say IM_TBS . Although i can not specify the TABLESPACE attribute directly , when building a domain index , right ? So , how can i do it ? This is the create index statement i use CREATE INDEX mytab_idx1 ON mytab( bcontent ) INDEXTYPE IS ctxsys.context ;Thanks a lot in advance .
RE: Intermedia text table design
Ranganath, You've defaulted to in-line storage of CLOBs. You could specify "Disable Storage In Row" and point the CLOBs to different tablespaces, thus spreading your I/O out over more drives. You can also define a custom Basic_Storage interMedia parameter, by which you spread out the 5 or 6 segment types of an interMedia index on different tablespaces. See Chapter 7 in "Oracle8i Application Developer's Guide - Large Objects (LOBs)" for details on LOB storage and the "Oracle8i interMedia Text Reference" for details on indexing parameters. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Ranganath K Sent: Friday, April 06, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, I have given below the procedure as how we are creating the tables, preference and indexing for the same. Could you please check if there is any other preference need to be set for CLOB Datatypes which I missed? ... TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Oracle Intermedia Search Query
- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, April 06, 2001 15:45 > Dear DBA Gurus, > > I have the following records in Oracle 8.1.6 database (CLOB fields). > > id title > 1 kid's > 2 kid and teen > 3 kid's > 4 kid's and teens > > If I write a query as > select * from site where contains(title,'kid''s') > 0 then it > displays all the 4 records where are I want only records 1, 3 and 4 only. > If I try with: select * from site where contains(title, 'kid||chr(39)||s') > > 0 then it is returning error ORA - 29902. How do I write the query in order > to return the correct result? Any help in this regard will be very much > appreciated. > 'S is a stop word (which is not indexed), so for the index server all the 4 rows are correct results of the query. Consult the manuals for setting the stop list preferences (a search for "BASIC_STOPLIST" should give u a hint) - probably you'll be able to set the stop list preferences in a way that suits your needs hth, Marin "When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking, because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, to have no goal. ..." Herman Hesse, "Siddhartha" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: intermedia text and dbms_job problem
bill this is a bug..infact it was happening in 8i and oracle said they will try to fix in 9i. u have to call the procedure in the ur job and embed the sync index in ur procedure. here is a snippet.u can try this way. create or replace procedure i_doc_sync is begin ctx_ddl.sync_index( idx_name => 'prb_title'); end; declare v_job number; begin dbms_job.submit( job=>v_job, what=>'i_doc_sync;', next_date=>sysdate, interval=>'sysdate+1/24'); end; that should work saiBill Tantzen <[EMAIL PROTECTED]> wrote: OK, I know I must be doing something wrong, would somebody please pointout what it is? I would like to set up a job to sync an intermedia textindex. Here is my job:SQL> select what from all_jobs where job = 2;WHAT-ctx_ddl.sync_index ( 'ctx_xml_text' );I can execute the procedute from the command line like so:SQL> execute ctx_ddl.sync_index ( 'ctx_xml_text' );PL/SQL procedure successfully completed.But the job itself fails:SQL> execute dbms_job.run ( 2 );BEGIN dbms_job.run ( 2 ); END;*ERROR at line 1:ORA-12011: execution of 1 jobs failedORA-06512: at "SYS.DBMS_IJOB", line 405ORA-06512: at "SYS.DBMS_JOB", line 267ORA-06512: at line 1in my init.ora I have:job_queue_processes = 4job_queue_interval = 60! I am in the ctxapp role, and ctxsys has granted me execute on ctx_ddl.The only other job works just fine.OS=Solaris, Version=8.1.7What the heck is going on?Thanks in advance,BillBill Tantzen University of Minnesota Libraries[EMAIL PROTECTED]612-626-9949 (office) 612-250-6125 (cell)I guess the man's a genius, but whata dirty mind he has, hasn't he? -- Nora Joyce-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Bill TantzenINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message! BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: intermedia text and dbms_job problem
Title: Message Sai, Thank you so very much! It worked perfectly!!! Bill Bill TantzenUniversity of Minnesota Libraries[EMAIL PROTECTED]612-626-9949 (office) 612-250-6125 (cell)I guess the man's a genius, but whata dirty mind he has, hasn't he? -- Nora Joyce -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sai SelvaganesanSent: Wednesday, October 08, 2003 3:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: intermedia text and dbms_job problem bill this is a bug..infact it was happening in 8i and oracle said they will try to fix in 9i. u have to call the procedure in the ur job and embed the sync index in ur procedure. here is a snippet.u can try this way. create or replace procedure i_doc_sync is begin ctx_ddl.sync_index( idx_name => 'prb_title'); end; declare v_job number; begin dbms_job.submit( job=>v_job, what=>'i_doc_sync;', next_date=>sysdate, interval=>'sysdate+1/24'); end; that should work sai
OT: RE: 817 Intermedia on AIX
I'd thought bootylicious would refer to Jennifer Lopez. joe >>> [EMAIL PROTECTED] 08/29/01 02:42PM >>>"The Bootylicious " "Gimme a PC and I'll Break It, Guaranteed" "The MONkey"Boy ! arn't we busy today.ROR mô¿ôm>>> [EMAIL PROTECTED] 08/29/01 01:57PM >>>Also - I ran into this problem on hp/ux: you may have to create the libraryhard coded with the oracle home path. REferencing $ORACLE_HOME (inuser_libraries) did not work.Lisa KoivuThe Bootylicious DBAFt. Lauderdale, FL, USA> -Original Message-> From: Mike J Kurth [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 11:21 AM> To: Multiple recipients of list ORACLE-L> Subject: Re: 817 Intermedia on AIX> > > You may want to connect as ctxsys and query the user_libraries view> to make sure the library paths are pointing to your new 8.1.7 Oracle_home.> Just a thought.> > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mike J Kurth> INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ron Rogers INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Adding intermedia Text to 8.1.6 database
Hello Can someone point me to documentation how to add intermedia text to a database in Oracle 8.1.6 (on NT)? I installed interMedia and can use in the database created by the setup but would like to add it to another database on the same server. The documentation that I have found at OTN refers to running few scripts that are in %ORACLE_HOME%\ctx\admin. That's all clear but I don't have the ctx\lib directory and obviously the libctxx8.so file required to build data dictionary. The interMedia works in the default database - I can build index of type ctxsys.context, do text search so all the libraries must be installed. But search for file libct*.so on all my hard drives returns nothing. Something else must be used... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
ORA-1410 on interMedia Text Index
Hi, 8.1.6.0.0 on Win2k with interMedia Text index on table of 4 million CLOB documents. It's been in stable operation for over 8 months, with approx. 70,000 documents being added daily, approx. 10,000 deleted daily, and a sync of the index each day. We started getting ORA-1410 "invalid ROWID" for Contains queries and ORA-600 [12700] errors in the Alert log. This happened a few days after we altered the DR$$R table to Cache Reads for its Data LOB column. Metalink Bug 1668041 indicates that changing Cache Reads to just Cache for the DR$...$R table solved the problem for an 8.1.7. WinNT DB. Has anyone else experienced this? I'm rebuilding the index now (for the 2nd time this week! - takes 7.25 hours) and want to know if this fix will work. Thanks for any advice or suggestions. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia: function index for like '%string%'
Title: Intermedia: function index for like '%string%' I'm no 'expert' but I can share what I've seen. interMedia has functionality built in to execute 'fuzzy' searches. However, when you use fuzzy() be prepared for much slower performance. I believe there was wildcard functionality too - I didn't use it. I stuck to the entire word match because performance was miserable if I used any of the functions provided. So, in short - a lot more work (maintaining the index) for a minimal improvement in performance. HTH Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]] Sent: Saturday, June 02, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: function index for like '%string%' good question, i've not tried any intermedia/context stuff. any experts out there? Joe "Thater, William" wrote: > > On Fri, 1 Jun 2001,Joseph S. Testa scribbled on the wall in glitter crayon: > > ->i spent about a week about 6 months ago looking for something to fill > ->that possibility to no avail. > > dumb question would a contex... oh excuse me InterMedia index work? > > -> > ->joe > ->Rachel Carmichael wrote: > ->> > ->> she knows why it isn't being used. What Suzy wants to know (and I do too, > ->> because I have a similar situation) is if there is a way to create an index > ->> that will let you search with the like clause. > ->> > ->> Unfortunately my gut instinct is that you can't make Oracle do that > ->> > ->> >From: "Hillman, Alex" <[EMAIL PROTECTED]> > ->> >Reply-To: [EMAIL PROTECTED] > ->> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > ->> >Subject: RE: function index for like '%string%' > ->> >Date: Fri, 01 Jun 2001 14:11:08 -0800 > ->> > > ->> >index is not used because you have leading % in the like predicate. > ->> > > ->> >Alex Hillman > ->> > > ->> >-Original Message- > ->> >Sent: Friday, June 01, 2001 5:09 PM > ->> >To: Multiple recipients of list ORACLE-L > ->> > > ->> > > ->> > > ->> >I've created a function index for lower(column_name). However the query > ->> >does > ->> >a like comparison rather than equality so the index isn't used. Is there a > ->> >way to create a function index for this? > ->> > > ->> >Here's the index and query: > ->> > > ->> >create index fx1_auth_users > ->> >on auth_users (lower(current_email) > ->> >tablespace app01_midx ; > ->> > > ->> >select current_email from auth_users > ->> >where lower(current_email) like '%datsit.com%' ; > ->> > > ->> >Thanks much, > ->> >Suzy > ->> >-- > ->> >Please see the official ORACLE-L FAQ: http://www.orafaq.com > ->> >-- > ->> >Author: Suzy Vordos > ->> > INET: [EMAIL PROTECTED] > ->> > > ->> >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: [EMAIL PROTECTED] (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 > ->> >als
Re: Intermedia Domain index and tablespace
take a look at the "Specifying Storage Attributes" section of http://technet.oracle.com/doc/inter.815/a67843/cddlpkg.htm#16740 there is an example for creating a storage preference for the index and assigning different components of the domain index to different tablespaces. after u have set the preferences up u'll have to create the index with something like: ===create index AAA on BBB.CCC(DDD) indextype is ctxsys.context parameters ('filter ctxsys.EEE storage FFF'); hth, Marin "When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking,because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, to have no goal. ..." Herman Hesse, "Siddhartha" - Original Message - From: andrey To: Multiple recipients of list ORACLE-L Sent: Thursday, March 15, 2001 12:55 Subject: Intermedia Domain index and tablespace Dear list ! I'm creating an Intermedia domain index , and i want to build the index ( and related DR$... tables and indexes) in a specific tablespace , say IM_TBS . Although i can not specify the TABLESPACE attribute directly , when building a domain index , right ? So , how can i do it ? This is the create index statement i use CREATE INDEX mytab_idx1 ON mytab( bcontent ) INDEXTYPE IS ctxsys.context ;Thanks a lot in advance .
RE: Intermedia Domain index and tablespace
You need to create preferences and specify them in your create index statement. This is all in the documentation, by the way. Also, this does not affect your IOT storage parms. You will have to modify those separately or you will blow maxextents as your index grows. Here's what mine look like exec ctxsys.ctx_ddl.create_preference('product_storage','BASIC_STORAGE'); exec ctxsys.ctx_ddl.set_attribute('product_storage','I_TABLE_CLAUSE','tablespace ctx_idx_a storage (initial 100m next 100m)'); exec ctxsys.ctx_ddl.set_attribute('product_storage','K_TABLE_CLAUSE','tablespace ctx_idx_a storage (initial 100m next 100m)'); . etc . And here's how I use it create index x on q.table(search_string) indextype is ctxsys.context parameters ( 'lexer product_pref storage product_storage datastore product_datastore' ) / 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 http://www.qode.com "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: andrey [mailto:[EMAIL PROTECTED]]Sent: Thursday, March 15, 2001 5:45 AMTo: Multiple recipients of list ORACLE-LSubject: Intermedia Domain index and tablespace Dear list ! I'm creating an Intermedia domain index , and i want to build the index ( and related DR$... tables and indexes) in a specific tablespace , say IM_TBS . Although i can not specify the TABLESPACE attribute directly , when building a domain index , right ? So , how can i do it ? This is the create index statement i use CREATE INDEX mytab_idx1 ON mytab( bcontent ) INDEXTYPE IS ctxsys.context ;Thanks a lot in advance .
RE: Intermedia Domain index and tablespace
I've done this and it works well. Steve Orr -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marin DimitrovSent: Thursday, March 15, 2001 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Intermedia Domain index and tablespace take a look at the "Specifying Storage Attributes" section of http://technet.oracle.com/doc/inter.815/a67843/cddlpkg.htm#16740 there is an example for creating a storage preference for the index and assigning different components of the domain index to different tablespaces. after u have set the preferences up u'll have to create the index with something like: ===create index AAA on BBB.CCC(DDD) indextype is ctxsys.context parameters ('filter ctxsys.EEE storage FFF'); hth, Marin "When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking,because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, to have no goal. ..." Herman Hesse, "Siddhartha" - Original Message - From: andrey To: Multiple recipients of list ORACLE-L Sent: Thursday, March 15, 2001 12:55 Subject: Intermedia Domain index and tablespace Dear list ! I'm creating an Intermedia domain index , and i want to build the index ( and related DR$... tables and indexes) in a specific tablespace , say IM_TBS . Although i can not specify the TABLESPACE attribute directly , when building a domain index , right ? So , how can i do it ? This is the create index statement i use CREATE INDEX mytab_idx1 ON mytab( bcontent ) INDEXTYPE IS ctxsys.context ;Thanks a lot in advance .
RE: Intermedia Domain index and tablespace
Andrey, You're right in that you cannot explicitly name the tablespace(s) in the Create Index statement. However, you can put the various (5 or 6 segments in all) pieces of an InterMedia Text index in different tablespaces by creating a Basic_Storage parameter, with suitable attributes. Your statement below would then have an additional clause such as: Parameters ('Datastore CtxSys.My_Direct_Datastore Storage CtxSys.My_Basic_Storage Memory 5000') ; That directs InterMedia to create the index according to the Attributes you define in My_Direct_Datastore and My_Basic_Storage. The Memory 5000 part tells InterMedia to use about 50MB of RAM to do the sorting, etc. required to build the index. Make this as big as you can, since it is the key to fast index creation - that is, if the table is large and already exists. See the chapter on Indexing (chapter 3 for Oracle 8.1.6) in the "Oracle8i interMedia Text Reference" for all the details. Hope this helps you. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of andreySent: Thursday, March 15, 2001 4:56 AMTo: Multiple recipients of list ORACLE-LSubject: Intermedia Domain index and tablespace Dear list ! I'm creating an Intermedia domain index , and i want to build the index ( and related DR$... tables and indexes) in a specific tablespace , say IM_TBS . Although i can not specify the TABLESPACE attribute directly , when building a domain index , right ? So , how can i do it ? This is the create index statement i use CREATE INDEX mytab_idx1 ON mytab( bcontent ) INDEXTYPE IS ctxsys.context ;Thanks a lot in advance .
Union Views on InterMedia Indexed Tables
I've discovered a workaround for an Oracle InterMedia Text error. Our platform: Oracle 8.1.6 on Windows2000 Our problem: We get the following errors when querying (with a Contains() expression) a Union All View of identically-structured tables, each with an InterMedia index on the same CLOB column: ORA-20000: interMedia Text error: DRG-10599: column is not indexed Each table can be successfully queried alone or within a Union All Select - just not when referenced in a view. The solution is to create a Select * From View on each individual table, then use those individual views in the Union All view. Bizarre, eh? Yes, but it works. It does not solve the problem of getting the same error messages as above when using the Score() function in a query that references the Union All view. This is a problem for us on both 8.1.6 and 8.1.7. BTW, 8.1.7 doesn't exhibit the above-mentioned problem that we experience on 8.1.6. 8.1.7 just gives the error when you use the Score() function. Hope this helps someone. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
indexing PDF's using intermedia (8.1.7), not happening
List, I have installed intermedia, and been using it for the last couple of weeks without nay problems, recently, after uploading a PDF documents in the blob column, i found out that the contents of PDF's are not being indexed !!! i have tried sync the index also.. all the other formats (word,ppt' etc) are indexed automatically (m running the ctxsrv) the ctxsys.ctx_index_errors tables show the following error when i try to index... DRG-11101: failed to open file C:\WINNT\TEMP\drgut27 i have searched metalink, and it says to create a new filter.. i did that too.. SQL> exec ctx_ddl.create_preference('myfilter', 'USER_FILTER'); SQL> exec ctx_ddl.set_attribute('myfilter', 'command', 'auto_filt.bat'); SQL> create index idx_documents on documents(blob_content)INDEXTYPE is ctxsys.context parameters ('filter myfilter section group ctxsys.html_section_group'); but still the PDF's do not appear in index !!!, all metalink docs point to ORA_HOME/ctx/bin directory !! but i could not locate the directory on my NT server !!! very wierd indeed... again.. the indexing works for all other formats... other than PDF's TIA Rahul The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775.-
Re: Adding intermedia Text to 8.1.6 database
Hi all I have found my answer... I have seen other people asking on other forums so the answer may help someone some day... On NT the library is: %ORACLE_HOME%\bin\oractxx8.dll Witold > Hello > > Can someone point me to documentation how to add intermedia text > to a database in Oracle 8.1.6 (on NT)? > I installed interMedia and can use in the database created by the > setup but would like to add it to another database on the same > server. The documentation that I have found at OTN refers to > running few scripts that are in %ORACLE_HOME%\ctx\admin. > That's all clear but I don't have the ctx\lib directory and obviously the > libctxx8.so file required to build data dictionary. > The interMedia works in the default database - I can build index of > type ctxsys.context, do text search so all the libraries must be > installed. But search for file libct*.so on all my hard drives returns > nothing. Something else must be used... > > Thanks > > Witold > == > Witold Iwaniec > Sr Software Developer > NovaLIS Technologies > [EMAIL PROTECTED] > http://www.novalistech.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Witold Iwaniec > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 8.1.7.2.5 interMedia Text Slow Sync - SOLVED
For what seems to be the few of you who use interMedia Text, I found the problem - it was ME. :-( I had set (in CTX_Parameters) Max_Index_Memory to 200MB (from the default of 12.5MB) and used 200MB when I created indexes, but had overlooked Default_Index_Memory (default of 12.5MB), which is used by CTX_DDL.Sync_Index. After I set Default_Index_Memory to 200MB, re-syncs jumped from about 750 CLOBs per minute to over 2,500 per minute. Oracle was able to sort an entire batch of 157,000 CLOBs in memory, instead of only about 8,000 at a time - surprise, surprise with 16 times the memory available. BTW, it didn't hurt that I spread the datafiles of the tablespaces that hold the DR$<>$X segments across 2 drives, instead of just 1. That boosted re-syncs from 600 CLOBs per minute to 750. I/O distribution never hurts. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Applewhite Sent: Thursday, January 24, 2002 9:35 AM To: Multiple recipients of list ORACLE-L We are experiencing very slow interMedia Text resyncs ( CTX_DDL.Sync_Index ) under 8.1.7.2.5 on Win2k Server. We upgraded from 8.1.6.0.0 to 8.1.7.2.5 earlier this month (both under Win2k Server) on essentially the same hardware. We used to see about 700-2000 CLOB documents per second indexed under 8.1.6, but now see only about 400-800. The low-high numbers relate to the size of the index being sync'd - low just before we roll out a monthly partition (total 2 million CLOBs), high just after (total 1 million CLOBs). Query performance is better under 8.1.7 - partly because I spread the DR$<>$I table across 3 drives. By the looks of the I/O pattern, I should spread DR$<>$X (the index on DR$<>$I table) across 2 or 3 drives as well. Anybody have any words of wisdom as to what I can do to speed things up? BTW, I'm curious at how 8.1.7 balances I/O. While it's writing to the DR$<>$X segment, it doesn't write to the online redo logs - it waits until it's reading from DR$<>$X segment before it writes to the redo logs. I wonder why it doesn't do the writes to redo in parallel with the writes to DR$<>$X. Thanks. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORA-1410 on interMedia Text Index
I was getting ORA-600 [12700] when I upgraded a 734 text database to 817. Ended up having to apply the latest patchset, I think it was 8172, to finally fix the problem. Has something to do with buffer cache corruption when Intermedia is trying to sync the index. The index loses its pointer to the row. Never got the ORA-1410 though. I have no idea if they have a patch for 816. If you contact Oracle, they will want you to analyze the base table and all the indexes and send them the trace file on the ORA-600. -Original Message- Sent: Wednesday, September 12, 2001 7:40 PM To: Multiple recipients of list ORACLE-L Hi, 8.1.6.0.0 on Win2k with interMedia Text index on table of 4 million CLOB documents. It's been in stable operation for over 8 months, with approx. 70,000 documents being added daily, approx. 10,000 deleted daily, and a sync of the index each day. We started getting ORA-1410 "invalid ROWID" for Contains queries and ORA-600 [12700] errors in the Alert log. This happened a few days after we altered the DR$$R table to Cache Reads for its Data LOB column. Metalink Bug 1668041 indicates that changing Cache Reads to just Cache for the DR$...$R table solved the problem for an 8.1.7. WinNT DB. Has anyone else experienced this? I'm rebuilding the index now (for the 2nd time this week! - takes 7.25 hours) and want to know if this fix will work. Thanks for any advice or suggestions. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuan, Amy M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
iFS and InterMedia - installation and configuration effort
List, For any of you that have setup and configure iFS and InterMedia, I was wondering if you'd care to give a ballpark estimate of how much time you think it would take for an experienced DBA ( me) do set this up. If it's not a big project ( few hours ) I'll give it a try for one of our developers. If a multiday project, we'll have to plan for it instead. Thanks Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Oracle Text (ConText/InterMedia) and realtime updates
Hey all, So, there we are, testing out InterMedia in 8i, in the hopes of using Oracle Text in 9i. Is there a way to automagically update the context index real-time? I tried a call to CTX_DDL.SYNC_INDEX in a trigger body, but of course the wrapped procedure does a COMMIT. The idea right now is to sync the index every minute via DBMS_JOB, but that just seems too hokey to me. Apparently, under ConText in Oracle7, the INT_RX procedure could be used in a trigger, but it's been desupported. (I'm guessing that locking was an issue?) Anyone have any ideas? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Parsing free-form text for InterMedia indexing
Hi all, I've been struggling with trying to provide our users with a quick text search. InterMedia's doing OK, but I'm having trouble setting it up because the text I'm searching is free-form data entered by several users over the span of years. In other words, it's a word-jumble. For example, one indexed string might contain "25 PIN", while another contains "25PIN", but I need to make sure that both come up in a query without needing the user to know to enter for multiple scenarios. How can that be indexed in IM? I think I want to have digits as separators, but not in words that are only digits, e.g. I don't want "123456" to be indexed as "1", "2", "3", "4", "5", "6". I'm also having other problems with volumninous printjoins, but I'll tackle one problem at a time. :) Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Intermedia Questions, Any Gurus on This Subject?
Help anybody, version 8.1.6.3 on UNIX 1. Storage clause of an intermedia index build. How to specify the buffer pool to KEEP or CACHE the index? 2. How to specify the tablespace for such a DOMAIN index. When put in tablespace clause, says its invalid option for domain index. Thanx = Vicky D. Foster, Oracle DBA email: [EMAIL PROTECTED] __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Context/Intermedia/OracleText index rebuilds and ORA-29863
Hey all, Spent last night (til the Witching Hour) patching from 8.1.7.2 to 8.1.7.4. During the process, we had all three of our Context indexes trashed. My guess is that it was because CTXSYS.CTX_DDL.INDEX_SYNC() DBMS_JOB was running while the CTX upgrade scripts were running. I thought it was funny that there were no instructions to break this job before the upgrade, but it did work in test back in September. Anyway, I filed a TAR, and after re-running the "dr0" admin scripts, we tried to rebuild the indexes online using: ALTER INDEX my_context_index REBUILD ONLINE; Alas, the error: ORA-29863: Warning in the Execution of ODCIINDEXCREATE Routine reared it's ugly puss. We checked the advice of the Metalink article on the error, but we didn't have any of those symptoms (out of Temp or Perm TS space) and ended up dropping and recreating the indexes. So, has anyone run across this error before? I'd hate to think I'm not able rebuild indexes, much less online... TIA! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: ORA-1410 on interMedia Text Index - SOLVED
Hi, Just a follow-up for you interMedia Text fans out there. The statement below worked for us to eliminate the ORA-1410 and ORA-600 [12700] errors. Alter Table DR$$R table to Cache Reads for its Data LOB column. Metalink Bug 1668041 indicates that changing Cache Reads to just Cache for the DR$...$R table solved the problem for an 8.1.7. WinNT DB. Has anyone else experienced this? I'm rebuilding the index now (for the 2nd time this week! - takes 7.25 hours) and want to know if this fix will work. Thanks for any advice or suggestions. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Oracle Text (ConText/InterMedia) and realtime updates
There is a server process that can run in the background to do this. Check out ctxsrv hth connor --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > Hey all, > > So, there we are, testing out InterMedia in 8i, in > the hopes of using Oracle > Text in 9i. Is there a way to automagically update > the context index > real-time? I tried a call to CTX_DDL.SYNC_INDEX in > a trigger body, but of > course the wrapped procedure does a COMMIT. > > The idea right now is to sync the index every minute > via DBMS_JOB, but that > just seems too hokey to me. Apparently, under > ConText in Oracle7, the > INT_RX procedure could be used in a trigger, but > it's been desupported. > (I'm guessing that locking was an issue?) > > Anyone have any ideas? > > TIA! > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Oracle Text (ConText/InterMedia) and realtime updates
Yeah, I thought about that, but according to Oracle, "ctxsrv" is desupported and will be removed "in a future version". I guess I'm hoping for something in the DB, too, instead of relying on an external program that needs the CTXSYS password hardcoded. Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Original Message- Sent: Tuesday, November 13, 2001 14:23 To: Multiple recipients of list ORACLE-L There is a server process that can run in the background to do this. Check out ctxsrv hth connor --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > Hey all, > > So, there we are, testing out InterMedia in 8i, in > the hopes of using Oracle > Text in 9i. Is there a way to automagically update > the context index > real-time? I tried a call to CTX_DDL.SYNC_INDEX in > a trigger body, but of > course the wrapped procedure does a COMMIT. > > The idea right now is to sync the index every minute > via DBMS_JOB, but that > just seems too hokey to me. Apparently, under > ConText in Oracle7, the > INT_RX procedure could be used in a trigger, but > it's been desupported. > (I'm guessing that locking was an issue?) > > Anyone have any ideas? > > TIA! > Rich Jesse System/Database -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Oracle Text (ConText/InterMedia) and realtime updates
Connor, Rich, There is no "real-time" update of an interMedia Text index. Even ctxsrv does the update periodically. According to the 8.1.6 docs (referring to the ctxsrv server)... "This server synchronizes the index with ALTER INDEX at regular intervals." Actually, you don't want real-time updates anyway. The more frequently (with smaller batches of new and/or updated rows) you sync your index, the more fragmented and "trashy" it gets, which degrades performance. Keep in mind that an interMedia Text index is *nothing* like a "regular" index. We sync the interMedia Text index on our main production table daily, after typically inserting 50,000 to 200,000 new CLOB documents into a 2-3 million row table. It takes 40 min. to a couple of hours (we're on 8.1.6 on Win2k). We used to use ctxsrv, but now use CTX_DDL.Sync_Index and life is good. ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- McDonald Sent: Tuesday, November 13, 2001 2:23 PM To: Multiple recipients of list ORACLE-L There is a server process that can run in the background to do this. Check out ctxsrv hth connor --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > Hey all, > > So, there we are, testing out InterMedia in 8i, in > the hopes of using Oracle > Text in 9i. Is there a way to automagically update > the context index > real-time? I tried a call to CTX_DDL.SYNC_INDEX in > a trigger body, but of > course the wrapped procedure does a COMMIT. > > The idea right now is to sync the index every minute > via DBMS_JOB, but that > just seems too hokey to me. Apparently, under > ConText in Oracle7, the > INT_RX procedure could be used in a trigger, but > it's been desupported. > (I'm guessing that locking was an issue?) > > Anyone have any ideas? > > TIA! > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Oracle Text (ConText/InterMedia) and realtime updates
Title: RE: Oracle Text (ConText/InterMedia) and realtime updates I would suggest researching an Autonomous Transaction fired from the trigger to get around the commit executed by CTX_DDL.SYNC_INDEX. Another approach I would pursue is to evaluate the use of Catalog Indexes (8.1.7). If your requirements fit within the catalog index limitations (more like an Intermedia Text-lite) then you are in luck since they are transactional, hence no need for periodic synchronization. HTH Tony Aponte -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Text (ConText/InterMedia) and realtime updates Hey all, So, there we are, testing out InterMedia in 8i, in the hopes of using Oracle Text in 9i. Is there a way to automagically update the context index real-time? I tried a call to CTX_DDL.SYNC_INDEX in a trigger body, but of course the wrapped procedure does a COMMIT. The idea right now is to sync the index every minute via DBMS_JOB, but that just seems too hokey to me. Apparently, under ConText in Oracle7, the INT_RX procedure could be used in a trigger, but it's been desupported. (I'm guessing that locking was an issue?) Anyone have any ideas? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Oracle Text (ConText/InterMedia) and realtime updates
Hey Tony, >From my understanding of an Autonomous Transaction (which admittedly isn't much), the sync would always be one update behind, correct? Because the auto-trans would execute the sync in the trigger body, the current update/insert of the indexed column that caused the trigger to fire would not be committed at the time of sync. Or am I missing something here? I glanced at the Catalog Index feature and methinks it deserves smore investigation. Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, November 13, 2001 17:00 To: Multiple recipients of list ORACLE-L I would suggest researching an Autonomous Transaction fired from the trigger to get around the commit executed by CTX_DDL.SYNC_INDEX. Another approach I would pursue is to evaluate the use of Catalog Indexes (8.1.7). If your requirements fit within the catalog index limitations (more like an Intermedia Text-lite) then you are in luck since they are transactional, hence no need for periodic synchronization. HTH Tony Aponte -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Oracle Text (ConText/InterMedia) and realtime updates
So, I fire up a Catalog Index on a column with an associated column in the index set (for ordering the results) and it comes back 10-12 times faster than the Context Index. The problem is that the result sets weren't the same. Upon investigating, I found out that catalog index searching ("catsearch") doesn't support wildcards, which we need. Bummer! Oh well, back to contexts. Thanks for your input! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, November 13, 2001 17:00 To: Multiple recipients of list ORACLE-L I would suggest researching an Autonomous Transaction fired from the trigger to get around the commit executed by CTX_DDL.SYNC_INDEX. Another approach I would pursue is to evaluate the use of Catalog Indexes (8.1.7). If your requirements fit within the catalog index limitations (more like an Intermedia Text-lite) then you are in luck since they are transactional, hence no need for periodic synchronization. HTH Tony Aponte -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia Questions, Any Gurus on This Subject?
There is a wealth of docs regarding this issue in OTN also check http://www.oracle.com/products/intermedia > -Original Message- > From: Oracle DBA [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 19, 2001 15:11 > To: Multiple recipients of list ORACLE-L > Subject: Intermedia Questions, Any Gurus on This Subject? > > Help anybody, version 8.1.6.3 on UNIX > > 1. Storage clause of an intermedia index build. How > to specify the buffer pool to KEEP or CACHE the index? > > 2. How to specify the tablespace for such a DOMAIN > index. When put in tablespace clause, says its invalid > option for domain index. > > > Thanx > > > = > Vicky D. Foster, > Oracle DBA > email: [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Spot the hottest trends in music, movies, and more. > http://buzz.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Oracle DBA > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Intermedia Questions, Any Gurus on This Subject?
Title: RE: Intermedia Questions, Any Gurus on This Subject? Hi Vicky, You need to create a preference to define the storage clause with CTX_DDL. I did this at a former employer and I don't have the scripts handy, sorry to say. The documentation does go over this in detail. You can specify just about everything for storage of your imt index in the preference. You can even put the separate pieces of the index in separate ts's. Buffer pool though, I'm not sure. See below a cutout from the doco. Specifying Storage Attributes The following examples specify that the index tables are to be created in the foo tablespace with an initial extent of 1K: begin ctx_ddl.create_preference('mystore', 'BASIC_STORAGE'); ctx_ddl.set_attribute('mystore', 'I_TABLE_CLAUSE', 'tablespace foo storage (initial 1K)'); ctx_ddl.set_attribute('mystore', 'K_TABLE_CLAUSE', 'tablespace foo storage (initial 1K)'); ctx_ddl.set_attribute('mystore', 'R_TABLE_CLAUSE', 'tablespace foo storage (initial 1K)'); ctx_ddl.set_attribute('mystore', 'N_TABLE_CLAUSE', 'tablespace foo storage (initial 1K)'); ctx_ddl.set_attribute('mystore', 'I_INDEX_CLAUSE', 'tablespace foo storage (initial 1K)'); end; HTH Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Oracle DBA [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 9:11 AM To: Multiple recipients of list ORACLE-L Subject: Intermedia Questions, Any Gurus on This Subject? Help anybody, version 8.1.6.3 on UNIX 1. Storage clause of an intermedia index build. How to specify the buffer pool to KEEP or CACHE the index? 2. How to specify the tablespace for such a DOMAIN index. When put in tablespace clause, says its invalid option for domain index. Thanx = Vicky D. Foster, Oracle DBA email: [EMAIL PROTECTED] __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Intermedia Questions, Any Gurus on This Subject?
You need to create preferences to specify storage parameters like: begin ctx_ddl.create_preference('storage_small','BASIC_STORAGE'); ctx_ddl.set_attribute('storage_small','I_TABLE_CLAUSE','tablespace LOBADM_01_SMALL_DATA'); ctx_ddl.set_attribute('storage_small','K_TABLE_CLAUSE','tablespace LOBADM_01_SMALL_DATA'); ctx_ddl.set_attribute('storage_small','R_TABLE_CLAUSE','tablespace LOBADM_01_SMALL_DATA'); ctx_ddl.set_attribute('storage_small','N_TABLE_CLAUSE','tablespace LOBADM_01_SMALL_DATA'); ctx_ddl.set_attribute('storage_small','I_INDEX_CLAUSE','tablespace LOBADM_01_SMALL_INDX'); ctx_ddl.set_attribute('storage_small','P_TABLE_CLAUSE','tablespace LOBADM_01_SMALL_DATA'); end; / Then create index like: create index lobadm.client_full_nm_indx on lobadm.client(full_nm) indextype is ctxsys.context parameters('storage lobadm.storage_small') / Hope this helps -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Context/Intermedia/OracleText index rebuilds and ORA-29863
I don't know how big your Indexes are but ... I drop the Index and create with NOPOPULATE and then do a CTX_DDL.SYNC_INDEX which can safely run in the background [I do this for the lone Context Index in 9iFS]. Hemant At 09:29 AM 14-01-03 -0800, you wrote: Hey all, Spent last night (til the Witching Hour) patching from 8.1.7.2 to 8.1.7.4. During the process, we had all three of our Context indexes trashed. My guess is that it was because CTXSYS.CTX_DDL.INDEX_SYNC() DBMS_JOB was running while the CTX upgrade scripts were running. I thought it was funny that there were no instructions to break this job before the upgrade, but it did work in test back in September. Anyway, I filed a TAR, and after re-running the "dr0" admin scripts, we tried to rebuild the indexes online using: ALTER INDEX my_context_index REBUILD ONLINE; Alas, the error: ORA-29863: Warning in the Execution of ODCIINDEXCREATE Routine reared it's ugly puss. We checked the advice of the Metalink article on the error, but we didn't have any of those symptoms (out of Temp or Perm TS space) and ended up dropping and recreating the indexes. So, has anyone run across this error before? I'd hate to think I'm not able rebuild indexes, much less online... TIA! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Context/Intermedia/OracleText index rebuilds and ORA-29863
Interesting idea, Hemant! It's not perfect, but it's a better alternative than either the ORA-29863 or populating the index on the rebuild. Thanks! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 15, 2003 8:54 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Context/Intermedia/OracleText index rebuilds and > ORA-29863 > > > > I don't know how big your Indexes are but ... > I drop the Index and create with NOPOPULATE and then do a > CTX_DDL.SYNC_INDEX > which can safely run in the background [I do this for the > lone Context Index > in 9iFS]. > Hemant -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Can InterMedia search for the presence or absence of a tag?
We're using InterMedia's XML section indexing (Oracle8.1.6.3), and mostly it works fine. However, I think it's indexing technique means that you: (i) cannot search for tags, eg contains(doc,'',1); (ii) cannot search for documents that have an empty tag (eg ). In both cases wildcard expansion doesn't work; for example: SQLPLUS> select doc from mytable where contains (doc, '% within publisher',0)>0; * ERROR at line 1: ORA-29902: error in executing ODCIIndexStart() routine ORA-2: interMedia Text error: DRG-50937: query too complex DRG-51030: wildcard query expansion resulted in too many terms Does anyone know of a way to do either (i) or (ii). Many thanks, Mike Monaghan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MONAGHAN, Mike INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Can I index this query? slightly OT-just InterMedia Text option
Jesse, since you o have such a good experience, could you please comment on the following: I have installed InterMedia Text (8.1.7 on Win2K sp.2) and 400MB has grown to 4.5 GB. There are 4 required indices, two for each table - on English and French version of varchar2(2000). Number of data base objects (user + ctxsys schemas) is 4 times larger. Search is perfect, inserts are using 100% CPU and killing the server. What have I done wrong? Do you have any idea? By the way, I have read TFM. TIA inka -Original Message- Sent: Wednesday, October 16, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I don't think it's really that big of a step. Until a rewrite of our 3rd-party inventory system (i.e. we didn't write the damn thing), we have to rely on part description stored in two separate tables (don't ask!) in order to search for parts. By installing and adding a Context/Intermedia/Text/whateverthehell index, we've gone from a two-table FTS (200K total rows on moderately wide tables) to sub-second index access. The difficulties in getting to this point are: 1) Understanding Oracle Text concepts. Read the book! 2) Being able to change the SQL to use the OText special "CONTAINS" clause. 3) Understanding the data to be able to setup your thesaurus correctly. 4) Determining if/when to rebuild the index. It took me about a week of research and testing before installing and using it (of course that week's work was spread over three weeks!), and a day or two of tweaks afterwards. In my case, I needed to also create some replication-like triggers and tables to combine data from our two tables into a single, indexable, searchable table. Fire it up! We've been pretty happy with the results (except when a user wants to return every row with a "Z" in the string...). GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Judge: "...and I'm no slouch myself." Ty: "Don't sell yourself short, Judge. You're a tremendous slouch." > -Original Message- > From: Connor McDonald [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 16, 2002 4:24 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Can I index this query? > > > You could always consider something like OracleText to > assist with these kind of searches, but thats a big > step.. > > hth > connor > > --- "Carle, William T (Bill), ALCAS" <[EMAIL PROTECTED]> > wrote: > Howdy, > > > > I have a table that has almost 2 million rows > > called eventqueueentry. The layout looks like this: > > > > Name Null? > > Type > > - > > > > EVENTID NOT NULL > > NUMBER(10) > > VER NOT NULL > > NUMBER(10) > > QUEUETYPE NOT NULL > > CHAR(16) > > PUBLISHER NOT NULL > > CHAR(16) > > CREATETIMENOT NULL > > DATE > > LASTREADTIME > > DATE > > REMOVETIME > > DATE > > CONTENTS NOT NULL > > VARCHAR2(4000) > > > > The users do a query that looks like this: > > > > SELECT EventId, QueueType, Publisher, CreateTime, > > LastReadTime, RemoveTime, > > Contents, Ver > > from > > EventQueueEntry where QueueType = 'CodeUpdate' AND > > Contents LIKE > > '%TrackingEventId=27668677%' ORDER BY EventId > > > > The queuetype field has only 3 different values. The > > value in the contents field is close to being unique > > (high cardinality) but, as you can see, they are > > picking off a value somewhere in the middle of a > > varchar2(4000) field. Understandably, their query is > > slow. Is there anything I can do with an index to > > speed this up? > > > > > > Bill Carle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name o
RE: Can I index this query? slightly OT-just InterMedia Text opt
Unfortunately Inka, I don't know if I can help you. There are so many other people on this list that are much more adept at perf tuning than I, it ain't even funny. Our single OText index only takes up 70MB total, and the indexed column has very low maintenance with less than 50 inserts/updates per day (no deletes). This is fine for a 6-way HP K570, even though the CPUs are "only" 200Mhz PA-RISC. If I had to guess, though, I'd say most folks here would have you start with a thourough 10046 trace on the SQL. Sorry I can't be of more help! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 16, 2002 12:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Can I index this query? slightly OT-just InterMedia Text > option > > > Jesse, > since you o have such a good experience, could you please > comment on the following: > I have installed InterMedia Text (8.1.7 on Win2K sp.2) and > 400MB has grown to 4.5 GB. > There are 4 required indices, two for each table - on English > and French version of varchar2(2000). Number of data base > objects (user + ctxsys schemas) is 4 times larger. > Search is perfect, inserts are using 100% CPU and killing the server. > > What have I done wrong? Do you have any idea? By the way, I > have read TFM. > > TIA > inka -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).