Re: Documents in or outside the database.
You also need to consider replication issues. If you will have another site that needs to store the documents, you will need to include that in the decision. For example, if you store them inside, Oracle can handle the propogation of the documents to the alternate site. If you store them outside, a separate mechanism is required. Rachel Carmichael wrote: > Compromise? BFILE? > > Unless we are actually trying to search the documents themselves, I > store documents outside the database and store the pathname to the > document location within the database itself. > > --- "M.Godlewski" <[EMAIL PROTECTED]> wrote: > > Hi listers, > > > > We are working on a project that will have documents as attachments. > > The developers want to store the documents outside the database on > > the application server. I want to store the documents inside the > > database for recovery purposes. Is there a white paper or document > > that has performance information for blob/clob storage and retrieval > > database performance information? > > > > TIA > > M. > > > > > > > > > > - > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site design software > > __ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > 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). begin:vcard n:Fink;Daniel x-mozilla-html:FALSE org:Sun Microsystems, Inc. adr:;; version:2.1 title:Lead, Database Services x-mozilla-cpt:;9168 fn:Daniel W. Fink end:vcard
RE: Documents in or outside the database.
And don't forget file permissions issues either--especially if there will ever be a firewall between your db and your users. If the docs are in the db, users won't need OS perms to read/write/delete anything on the filesystem... Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, September 10, 2003 10:55 AM To: Multiple recipients of list ORACLE-L You also need to consider replication issues. If you will have another site that needs to store the documents, you will need to include that in the decision. For example, if you store them inside, Oracle can handle the propogation of the documents to the alternate site. If you store them outside, a separate mechanism is required. Rachel Carmichael wrote: > Compromise? BFILE? > > Unless we are actually trying to search the documents themselves, I > store documents outside the database and store the pathname to the > document location within the database itself. > > --- "M.Godlewski" <[EMAIL PROTECTED]> wrote: > > Hi listers, > > > > We are working on a project that will have documents as attachments. > > The developers want to store the documents outside the database on > > the application server. I want to store the documents inside the > > database for recovery purposes. Is there a white paper or document > > that has performance information for blob/clob storage and retrieval > > database performance information? > > > > TIA > > M. > > > > > > > > > > - > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site design software > > __ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E 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: Documents in or outside the database.
You might as well take a look at the following asktom link: http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:663024378020 HTH GovindanK On Thu, 11 Sep 2003 11:24 , Pardee, Roy E <[EMAIL PROTECTED]> sent: >And don't forget file permissions issues either--especially if there >will ever be a firewall between your db and your users. If the docs are >in the db, users won't need OS perms to read/write/delete anything on >the filesystem... > >Roy Pardee >Programmer/Analyst/DBA >SWFPAC Lockheed Martin IT >Extension 8487 > >-Original Message- >Sent: Wednesday, September 10, 2003 10:55 AM >To: Multiple recipients of list ORACLE-L > > >You also need to consider replication issues. If you will have another >site that needs to store the documents, you will need to include that in >the decision. For example, if you store them inside, Oracle can handle >the propogation of the documents to the alternate site. If you store >them >outside, a separate mechanism is required. > >Rachel Carmichael wrote: > >> Compromise? BFILE? >> >> Unless we are actually trying to search the documents themselves, I >> store documents outside the database and store the pathname to the >> document location within the database itself. >> >> --- "M.Godlewski" [EMAIL PROTECTED]> wrote: >> > Hi listers, >> > >> > We are working on a project that will have documents as attachments. >> > The developers want to store the documents outside the database on >> > the application server. I want to store the documents inside the >> > database for recovery purposes. Is there a white paper or document >> > that has performance information for blob/clob storage and retrieval >> > database performance information? >> > >> > TIA >> > M. >> > >> > >> > Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K 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: Documents in or outside the database.
Rachel, The documents would basically be just attachments the web client would want to view, so bfiles are reasonable. Thanks,Rachel Carmichael <[EMAIL PROTECTED]> wrote: Compromise? BFILE?Unless we are actually trying to search the documents themselves, Istore documents outside the database and store the pathname to thedocument location within the database itself.--- "M.Godlewski" <[EMAIL PROTECTED]>wrote:> Hi listers,> > We are working on a project that will have documents as attachments. > The developers want to store the documents outside the database on> the application server. I want to store the documents inside the> database for recovery purposes. Is there a white paper or document> that has performance information for blob/clob storage and retrieval> database performance information?> > TIA> M.> > > > > -> Do you Yahoo!?> Yahoo! SiteBuilder - Free, easy-to-use web site design software__Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design softwarehttp://sitebuilder.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Rachel CarmichaelINET: [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). Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
Re: Documents in or outside the database.
Compromise? BFILE? Unless we are actually trying to search the documents themselves, I store documents outside the database and store the pathname to the document location within the database itself. --- "M.Godlewski" <[EMAIL PROTECTED]> wrote: > Hi listers, > > We are working on a project that will have documents as attachments. > The developers want to store the documents outside the database on > the application server. I want to store the documents inside the > database for recovery purposes. Is there a white paper or document > that has performance information for blob/clob storage and retrieval > database performance information? > > TIA > M. > > > > > - > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).