Re: Blobs vs Bfile in 10g. Pros and Cons?

From: Jeremy <>
Date: Mon, 9 Nov 2009 10:03:42 -0000
Message-ID: <MPG.2561f9581d6f8f0b9897a9_at_News.Individual.NET>

In article <4af71e92$0$83251$>, says...>
> 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...

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.

Received on Mon Nov 09 2009 - 04:03:42 CST

Original text of this message