Re: LOb's vs Bfiles

Justin Coleman wrote:
>
> Dear All,
>
> I am presently debating about if I wish to store 2 million rich multimedia
> data files as LOB's in the database or as Bfile references in the Database.
> I think I should use LOB's?
>
> Do must people use Bfile references or LOB's? What are the disadvantages of
> LOB's?
>
> Cheers,
> Justin
>

IMHO I'd favour BFILES over LOBs if you have the choice. In fact it depends on volumes, and what you want to do on your data. If you want to apply functions (when searching) to it, quite obviously you have to store everything inside the database; same if you need to replicate. On the other hand, I have not experienced a lot with LOBs yet, so consider the following more as a list of questions than answers, but consider everything which revolves around the data (rollback segments, redo logs) and wonder how it will behave with LOBs.  As far as when you are storing a lot of data you have to work closely with the SA, I think that BFILEs are something s/he will understand better than the Oracle black box. It also matters.

--
Regards,

  Stephane Faroult
  Oriole Corporation
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).