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 -> BLOB or BFILE ?

BLOB or BFILE ?

From: david chan <davidchantf_at_hotmail.com>
Date: 25 Sep 2002 13:29:37 -0700
Message-ID: <dca7348f.0209251229.eba70df@posting.google.com> 





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 Wed Sep 25 2002 - 15:29:37 CDT












Original text of this message













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