Re: Storing large files as blobs
From: Tim Boemker <tim_boemker_at_zacatecas.optimum.com>
Date: 1995/06/20
Message-ID: <3s6lgd$53f_at_jalisco.optimum.net>#1/1
Date: 1995/06/20
Message-ID: <3s6lgd$53f_at_jalisco.optimum.net>#1/1
In article <3rtmjp$m0m_at_kadath.zeitgeist.net> mattm_at_well.com (Matthias Moran) writes:
> Are there any problems storing large numbers of large files as blobs
> in an Oracle database ? and how would you go about getting the files
> into the database using ProC if you can't read an entire file into memory.
While it is possible to retrieve a LONG piecemeal, it is not possible to store it the same way: the entire value must be stored at once. You can only store a 2G LONG if you can malloc 2G of virtual memory. (Oracle has a pending enhancement request on this.)
Tim Boemker
Optimum Group
(513) 577-7785
Received on Tue Jun 20 1995 - 00:00:00 CEST