Xref: alice comp.databases.oracle.server:33493
From: "Pete Johnson" <P.Johnson@ste0426.x400.icl.co.uk>
Newsgroups: comp.databases.oracle.server
References: <910717043.4161.0.nnrp-02.c1ed9a88@news.demon.co.uk>
Subject: Re: How do I get 2GB of array data in?!
Date: Wed, 11 Nov 1998 12:12:06 -0000
Lines: 20
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MIMEOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <36497d46.0@145.227.194.253>
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!join.news.pipex.net!pipex!news.fjcomp.com!145.227.194.253!172.19.12.105


>* 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