Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DIRECTORIES and BFILE problems
JavaDeveloper wrote:
>
> I'm thinking about the convenience of storing many many files in BLOB. I
> calculated that as result I achieve about 8 Gb of data as a whole (every
> file is about 60 Kb). Maybe a BFILE is better?
>
> Any suggestion?
>
If in doubt choose BLOB over BFILE. It may take up space but space is cheap these days and the BLOBS will be easier to take care of:
Pay close attention to how Oracle is storing your BLOBS. Reading the manuals will be worthwhile.
David Rolfe
Orinda Software
Dublin, Ireland
Received on Mon Mar 07 2005 - 03:04:48 CST