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

Hi,
Which version of oracle are U using?
Where is the data source, is it a flat file, or from another database running on the same system?.
Have U planned partioning options?

Mohamed

drona_rom_at_my-deja.com wrote:

> 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 - 14:26:54 CST