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

At present we are using 7.3.4. We have planned one table per day. Data is read by one of the front end process and kept at memory. Then the interface reads it and loads it. How do you think partions enhance the speed of insertion?
thanks
Drona

In article <387CE323.689DDB00_at_assigncorp.com>,   mbuhari_at_assigncorp.com wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 13 2000 - 07:36:36 CST