I've done this with 'small' LONGs, but not yet with BLOBs.
My opinion is that if you have a very large number of small
small BLOBs, it is easier to manage them inside the database
rather than outside. File systems tend to get in trouble with
very large numbers of file, and addressing that problem by
using large numbers of hierarchical directories is a major
pain.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
marciat_at_my-deja.com wrote in message <8s1rae$7dv$1_at_nnrp1.deja.com>...
>Does anybody out there have experience with large databases (millions
>of records) storing BLOBs? Is Oracle capable of holding and managing
>millions of records of internal BLOB's, or is there some limit point at
>which it becomes infeasible to store them internally from a management
>standpoint and you would recommend using something on the order of
>BFILE's instead?
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Oct 13 2000 - 14:10:15 CDT
