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
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.comReceived on Sun Jun 23 1996 - 00:00:00 CEST