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 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).
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).
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).