Re: Insert 90MB data file in one cell
Date: Sat, 08 May 1999 10:07:40 GMT
Message-ID: <7h12db$5e9$1_at_nnrp1.deja.com>
Klim,
as far as I know that is not possible, but
you could use LOB (introduced with Oracle 8) and
load the files into the LOB via provided
packages.
Regards
Dante
In article <7g441b$e5l$1_at_nnrp1.dejanews.com>,
klimsamgin <klimsamgin_at_yahoo.com> wrote:
> Hi!
>
> I use LONG RAW columns to store large binary datafiles in ORACLE7
> under Solaris 2.5 (for example, 90MB file).
> And when I insert this big value in the table's cell
> at a heat, my PRO*C program can't allocate
> enough memory in the system (90MB buffer with data).
> To resolve this trouble, I should insert small
> pieces of this file in the cell(for examle, 1000x90KB, 1000 pieces).
> But how can I do this? Which command need used?
>
> Of couse, I can use 1000 cells, but what about one cell?
>
> Thanks,
> Klim.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat May 08 1999 - 12:07:40 CEST