Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Blobs vs Bfile in 10g. Pros and Cons?

105 views
Skip to first unread message

Rich

unread,
Nov 7, 2009, 2:08:04 PM11/7/09
to

Our department is uses 10g.

We will be loading PDF files and/or pictures into our database.

What are the pros and cons verses Bfile and Blobs. What has been your
experience?

Regards

Message has been deleted

Shakespeare

unread,
Nov 8, 2009, 2:40:11 PM11/8/09
to
Rich schreef:

LOBS reside inside your database, and thus are included in your backup,
securtity etc. Uploading will take some time.
BFiles are pointers to objects outside your database, and will not be
backed up with regular database backups. But on the other hand, are
easier to read/write woth tools outside the database.


It all depends on your business requirements...

Shakespeare

Jeremy

unread,
Nov 9, 2009, 5:03:42 AM11/9/09
to
In article <4af71e92$0$83251$e4fe...@news.xs4all.nl>, wha...@xs4all.nl
says...>

BFILE method of course also means no db-enforced referential integrity -
you have no means of knowing that the BFILE is still present, it has
been altered etc.

--
jeremy

Rich

unread,
Nov 9, 2009, 2:45:47 PM11/9/09
to

Thanks for the reply.

I read that LOB's can store 4GB of data. Is that a grand total for the
database? Or is that per record? For example, if I have 10 records in
the database does that mean that I can have 40GB of data in the BLOB?

Shakespeare

unread,
Nov 9, 2009, 5:13:19 PM11/9/09
to
Rich schreef:

It's per LOB. But LOB's can be up to 128Tb since 10g.
See
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14250/oci07lob.htm#i444306
But only with the OCI interface.

See also

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14249/adlob_data_interface.htm#i1012579

but that article is full of errors and looks like it's written in a hurry.

Shakespeare

Vladimir M. Zakharychev

unread,
Nov 12, 2009, 10:14:18 AM11/12/09
to

For the sake of manageability, consistency, security, reliability,
portability, etc. don't even think about using BFILEs (they have their
uses but storing binary data in an Oracle database is not one of
them.) LOBs are the way to go as they provide for all of the above and
a lot more. Initially loading existing files into the database will
take some time, but your effort will surely be rewarded. and it won't
take long anyway. There are many ways to accomplish this: SQL*Loader,
XML DB, PL/SQL using DBMS_LOB interfaces, some ETL tool that supports
LOB mass-loading. Getting them out is easy, too.

My $0,02.

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

0 new messages