Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: BLOB or BFILE ?
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 Thu Sep 26 2002 - 07:50:06 CDT