Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: BLOB or BFILE ?
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