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

> 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 Received on Wed Nov 11 1998 - 15:01:36 CST