Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: -- advantage BLOB or file on file system --

Re: -- advantage BLOB or file on file system --

From: Hans Forbrich <hforbric_at_yahoo.net>
Date: Tue, 27 Jan 2004 16:49:12 GMT
Message-ID: <401695CF.B9E35D57@yahoo.net>


REM wrote:
>
> I have some problems. It's dilemma between BLOB, BFILE and takes care of
> file on file system. What it's advantage??
> I import some PDF document in BLOB filed in my database. It's about 1000
> documents on day.
>
> My first question is: if I have a PDF on file system about 100 kb and if I
> import this in BLOB field in database. How much it's take more recourse.
>
> How I can measure largeness of BLOB field or how I can measure spacious of
> the table?

From the database perspective, BFile is pointer to eternal data and not the actual data. The data does not even need to exist. The database has no right to update the data, nor IIRC will it natively do backup (or assist with recovery). However, some capabilities of the database support reading the contents of the external file.

Oracle has done a wonderful thing - they have written a document called "Application Developer's Guide - Large Objects (LOBs)" - designed to answer questions like yours. It is available at http://docs.oracle.com. Please consider reading it. Received on Tue Jan 27 2004 - 10:49:12 CST

Original text of this message

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