Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Blobs vs Bfile in 10g. Pros and Cons?
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  6 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Rich  
View profile  
 More options Nov 7, 2:08 pm
Newsgroups: comp.databases.oracle.misc
From: Rich <richma...@earthlink.net>
Date: Sat, 7 Nov 2009 11:08:04 -0800 (PST)
Local: Sat, Nov 7 2009 2:08 pm
Subject: Blobs vs Bfile in 10g. Pros and Cons?

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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Shakespeare  
View profile  
 More options Nov 8, 2:40 pm
Newsgroups: comp.databases.oracle.misc
From: Shakespeare <what...@xs4all.nl>
Date: Sun, 08 Nov 2009 20:40:11 +0100
Local: Sun, Nov 8 2009 2:40 pm
Subject: Re: Blobs vs Bfile in 10g. Pros and Cons?
Rich schreef:

> 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

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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jeremy  
View profile  
 More options Nov 9, 5:03 am
Newsgroups: comp.databases.oracle.misc
From: Jeremy <jeremy0...@gmail.com>
Date: Mon, 9 Nov 2009 10:03:42 -0000
Local: Mon, Nov 9 2009 5:03 am
Subject: Re: Blobs vs Bfile in 10g. Pros and Cons?
In article <4af71e92$0$83251$e4fe5...@news.xs4all.nl>, what...@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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Rich  
View profile  
 More options Nov 9, 2:45 pm
Newsgroups: comp.databases.oracle.misc
From: Rich <richma...@earthlink.net>
Date: Mon, 9 Nov 2009 11:45:47 -0800 (PST)
Local: Mon, Nov 9 2009 2:45 pm
Subject: Re: Blobs vs Bfile in 10g. Pros and Cons?
On Nov 8, 2:40 pm, Shakespeare <what...@xs4all.nl> wrote:

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?


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Shakespeare  
View profile  
 More options Nov 9, 5:13 pm
Newsgroups: comp.databases.oracle.misc
From: Shakespeare <what...@xs4all.nl>
Date: Mon, 09 Nov 2009 23:13:19 +0100
Local: Mon, Nov 9 2009 5:13 pm
Subject: Re: Blobs vs Bfile in 10g. Pros and Cons?
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/oci07l...
But only with the OCI interface.

See also

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14249/adlob_...

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

Shakespeare


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Vladimir M. Zakharychev  
View profile  
 More options Nov 12, 10:14 am
Newsgroups: comp.databases.oracle.misc
From: "Vladimir M. Zakharychev" <vladimir.zakharyc...@gmail.com>
Date: Thu, 12 Nov 2009 07:14:18 -0800 (PST)
Local: Thurs, Nov 12 2009 10:14 am
Subject: Re: Blobs vs Bfile in 10g. Pros and Cons?
On Nov 9, 10:45 pm, Rich <richma...@earthlink.net> wrote:

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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google