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: Searching through BLOBS & BFILES

Re: Searching through BLOBS & BFILES

From: Geoff <nospam_at_nospam.com>
Date: Mon, 12 Jun 2006 23:05:26 GMT
Message-ID: <Wqmjg.5141$o4.1312@newsread2.news.pas.earthlink.net> 





> 1. Should I use a BLOB or BFILE data type & why would i use one over

> the other?




BFILEs are files under the control of your operating system.  BLOBs are 
files under the control of the database.  Pointers to the file are stored in 
the table, not the file itself.  In the case of a bfile, if that file is 
moved then the pointer is no longer valid.



-g
Received on Mon Jun 12 2006 - 18:05:26 CDT












Original text of this message













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