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

From: Peter Jones <peter.jones_at_richmond-hill.demon.co.uk>
Date: Thu, 12 Nov 1998 09:27:44 -0000
Message-ID: <910862954.10377.1.nnrp-02.c1ed9a88@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
>

Thanks - I think this is what I'm trying at the moment. Even though I can insert a row with the 100 element arrays in it, I still have 150000 rows to do!

Is there a method of inserting more than one row at a time?

Peter Received on Thu Nov 12 1998 - 03:27:44 CST