Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: BLOB or BFILE ?

Re: BLOB or BFILE ?

From: Mike Ault <mikerault_at_earthlink.net>
Date: 27 Sep 2002 07:09:24 -0700
Message-ID: <37fab3ab.0209270609.5c1f285c@posting.google.com>


I agree with Svend, Use the database to store them. You get better security (nothing like that call...Eh...where those pdf files in directory X important? I accidentally deleted them...) and you can control backup and access better.

Mike Ault
Svend Jensen <svend.jensenKILLSPAM_at_it.dk> wrote in message news:<3D93027E.3000601_at_it.dk>...
> U said it; all are critical data.
> Leave them inside the database and back them up with the database.
> rgds
>
> david chan wrote:
>
> > Hi,
> > I need to store some pdf file (about 50kb each) into oracle 8.1.7.
> > Which datatype (BLOB, BFILE) is better? As I understand BLOB is inside
> > database, BFILE is outside database. And the number of records are
> > about 6000 in about 3 years but all are critical data.
> > After I store the PDF file, I also need to retrive it back probally
> > once or two times.
> > Thanks.
> >
> > David
> >
Received on Fri Sep 27 2002 - 09:09:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US