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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
