Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help!!! What is the best way to load 20 million calls per day.
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
![]() |
![]() |