| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: -- advantage BLOB or file on file system --
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.
-- jeremyReceived on Mon Jan 26 2004 - 05:44:02 CST
![]() |
![]() |