In memory bulk import/export

From: Hector L. Alicea <75703.1706_at_CompuServe.COM>
Date: 1996/06/23
Message-ID: <4qki7v$gkn$1_at_mhadg.production.compuserve.com>#1/1


What is the best way to write a program which takes data from an in-memory buffer and insert it into an oracle database version 7.2 under Windows NT and HP-UX. I will be inserting about 2 million rows a day and performance is critical. I do not want to store the data into a file and then execute the imp72 program because I would be waisting time writing to a file temporarily.

I would like to go straight from memory into the oracle instance with no copying of data in between into some temporary buffer
(other than on a row by row or group of rows basis).

Thanks

Hector
(hector_at_manu.com)

-- 
-------------------------------------------------------------
5th Floor                            voice: (301) 984-5136
2115 East Jefferson St.                fax: (301) 984-5486
Rockville, MD  20852                 email: hector_at_manu.com
Received on Sun Jun 23 1996 - 00:00:00 CEST

Original text of this message