Re: How do I get 2GB of array data in?!

From: Ronald <ronr_at_wxs.nl>
Date: Mon, 16 Nov 1998 6:30:00 +0100
Message-ID: <01HW.B27576E8000092AE020BE630@news.wxs.nl>

On Thu, 12 Nov 1998 10:27:44 +0100, Peter Jones wrote (in message <910862954.10377.1.nnrp-02.c1ed9a88_at_news.demon.co.uk>):

> 
> 
> Pete Johnson wrote in message <36497d46.0_at_145.227.194.253>... 

>> You can actually do array inserts in PL/SQL 8 - so effectively you can
>> read the file into memory and then do one array insert and a commit. Don't
>> know any limitations that might be a problem but can't remember exactly
>> how to set up the insert - see doco
>>

Why don't you use sqloader with direct path ? It writes directly to the datafiles.
--
Ronald

---

mailto:ronr_at_wxs.nl
http://home.wxs.nl/~ronr/RonR.html (last update: june 8th, 1998) http://www.maccentral.com/news/9804/migration.shtml (forward migration home)

I think so I mac ! Received on Sun Nov 15 1998 - 23:30:00 CST