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
RE: Intermedia tag problem
Hi, You will have to change your input data and replace the with lt;. 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: - amp; - quot; ' - apos; - lt; - gt; 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: SYCyane/SYMANPhibro Energy */MAN 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: SYCyane 10 /SYMANPhibro Energy */MAN 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 lt;. 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: - amp; - quot; ' - apos; - lt; - gt; 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: SYCyane/SYMANPhibro Energy */MAN 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: SYCyane 10 /SYMANPhibro Energy */MAN 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).
Re: interMedia Textkey (DRG-10826)
All... slapping hand to forehead 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: 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 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 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$YourIndexName$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
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$YourIndexName$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
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$YourIndexName$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$YourIndexName$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.
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$YourIndexName$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
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).
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 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: 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
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
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?
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 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: 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 indexAAA 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) ina 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 INDEXmytab_idx1 ONmytab( 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 indexx onq.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) ina 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 INDEXmytab_idx1 ONmytab( 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 indexAAA 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) ina 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 INDEXmytab_idx1 ONmytab( 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) ina 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 INDEXmytab_idx1 ONmytab( bcontent ) INDEXTYPE IS ctxsys.context;Thanks a lot in advance .