Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I get 2GB of array data in?!
>* Use a PL/SQL procedure to read from the file and INSERT into the database
>(doing COMMITs every few thousand)
>
>* Write an OCI program to do it (I dont have ProC)
>
>* Preprocess the file into a 150000 INSERT statements and use SQL*Plus?!
>
>I have complete control (within reason) over the input file format, I dont
>care how elegant/inelegant it is (as this is not part of the study), I just
>need it done in days rather than weeks.
>
>All creative responses gratefully received!
>
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
Received on Wed Nov 11 1998 - 06:12:06 CST