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: -- advantage BLOB or file on file system --

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

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Mon, 26 Jan 2004 11:44:02 -0000
Message-ID: <MPG.1a7f0dd3f6a2585f989a41@news.individual.net>


In article <bus0nr$enu$3_at_ls219.htnet.hr>, ilica.brnadic_at_zg.hinet.hr says...
> 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.
>

One advantage is portability of the database and its contents and another is in security - backing up the database will back up BLOBs too, whereas a separate backup would be required for the docs if stored as BFILEs.

-- 

jeremy
Received on Mon Jan 26 2004 - 05:44:02 CST

Original text of this message

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