Re: Blobs vs Bfile in 10g. Pros and Cons?
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Sun, 08 Nov 2009 20:40:11 +0100
Message-ID: <4af71e92$0$83251$e4fe514c_at_news.xs4all.nl>
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
Date: Sun, 08 Nov 2009 20:40:11 +0100
Message-ID: <4af71e92$0$83251$e4fe514c_at_news.xs4all.nl>
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 Received on Sun Nov 08 2009 - 13:40:11 CST