Re: Blobs vs Bfile in 10g. Pros and Cons?
From: Jeremy <jeremy0505_at_gmail.com>
Date: Mon, 9 Nov 2009 10:03:42 -0000
Message-ID: <MPG.2561f9581d6f8f0b9897a9_at_News.Individual.NET>
In article <4af71e92$0$83251$e4fe514c_at_news.xs4all.nl>, whatsin_at_xs4all.nl 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...
Date: Mon, 9 Nov 2009 10:03:42 -0000
Message-ID: <MPG.2561f9581d6f8f0b9897a9_at_News.Individual.NET>
In article <4af71e92$0$83251$e4fe514c_at_news.xs4all.nl>, whatsin_at_xs4all.nl 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.
-- jeremyReceived on Mon Nov 09 2009 - 04:03:42 CST