Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help!!! What is the best way to load 20 million calls per day.

Help!!! What is the best way to load 20 million calls per day.

From: <drona_rom_at_my-deja.com>
Date: Wed, 12 Jan 2000 19:29:20 GMT
Message-ID: <85iklr$fm1$1@nnrp1.deja.com>


Hello,
Can someone give me ideas on different method of loading large amount of data to a table inOracle database. My company prefers loading directly from memory instead of writing to file and then use SQL*Loader. The entire data has to be loaded to single table. I have created table such that data will not span more than 3 extents. During loading time only primary key (id) will be on. This key is generated by sequence generator. Currently we use Roguwave interface, which is very slow since it does not re-use bind variables.
Any suggestion will be of great help.
Thanks
Drona

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 12 2000 - 13:29:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US