Re: loading data

You think imp80 is fast? I think it is very slow, we are going to abandon imp80 for SQL*Loader (direct path import) and similar tools soon. A database of 4 GB took approximately 50 hours to load whith imp80. No indices, primary/foreign keys were activated. I have just heard that Platinum (http://www.platinum.com) has some very good data loading utilities, but have not got more detailed information.

If anyone follow this thread it would be very interesting to hear about loading tools.

Best Regards
/August Linnman

Avner Lewenstein <lavner_at_hotmail.com> wrote in message news:7d8283$7e3$1_at_news.netvision.net.il...
> I am looking for a fast and eficient way to insert data into oracle 8.
> I wonder how imp80 is doing it so fast.
> Is there some API that van be used to import data?
> Can I get the format of oracle's export file so I can write data to file
and
> use imp80?
> Is there another way to insert data other the the above mentioned and
simple
> one row at a time insert SQL?
>
> Thanks
>
> Avner_at_eventuslog.com
>
>
>
Received on Tue Apr 06 1999 - 01:43:48 CEST