Xref: alice comp.databases.oracle.server:33551
Path: alice!news-feed.fnsi.net!news.idt.net!news-peer.gip.net!news.gsl.net!gip.net!newsfeed.cwix.com!206.63.63.70!nwnews.wa.com!brokaw.wa.com!not-for-mail
From: Dan Morgan <dmorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: How do I get 2GB of array data in?!
Date: Wed, 11 Nov 1998 13:01:36 -0800
Organization: EXE
Lines: 18
Message-ID: <3649FB30.26AE3B74@exesolutions.com>
References: <910717043.4161.0.nnrp-02.c1ed9a88@news.demon.co.uk>
Reply-To: dmorgan@exesolutions.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.06 [en] (WinNT; I)
To: Peter Jones <peter.jones@richmond-hill.demon.co.uk>

> As part of a benchmarking/prototyping exercise I need to load about 2GB of
> data into an 8.0.5 database on Solaris 2.6. This corresponds to
> approximately 150,000 rows each representing about 100 timestamped
> measurements of 20-odd parameters for elements in a telecoms network. The
> target table uses VARRAYs to store the 100 measurements for each parameter.
>
> I was planning to use the SQL Loader but it seems that it does not support
> loading arrays or indeed any of the new data types in the Oracle 8 Object
> Option.
>
> What options do I have?

Use SQL*Loader to load a flat file table with your data.
Use a stored procedure to load the final tables.
This will also allow for sophisticated error checking.

Daniel A. Morgan