Re: Import into a database takes a long time

From: Sean Fitzgerald <sfitzgerald_at_centuryinter.net>
Date: Wed, 25 Nov 1998 19:15:51 -0500
Message-ID: <97172.781$w91.456446@newsread1-mx.centuryinter.net>

I have also used Platinum's fast unload along with their TSreorg. With TSreorg I was able to unload a 1 GB table, drop it and reload it in 14 minutes compared to 75 minutes using Oracle's direct export and conventional import. This was on a SUN E5000 with 6 336MHz cpus and 4 GB ram (disks were EMC running Veritas quick i/o file systems).

Sean Fitzgerald, Senior DBA, OfficeMax, Inc.

Terry Ball wrote in message <365C5940.B0EC991D_at_csgsystems.com>...
>We have used FastUnload from Platinum. It is everything they say it is.
You can unload the
>data in a sqlloader style format and use direct load to get the data back
in. You will need to
>have the object you are loading into pre-created before you can load it as
it uses sqlloader to
>put the data into the table(s).
>
>Terry Ball
>Sr. DBA, CSG Systems, Inc.
>
Received on Wed Nov 25 1998 - 18:15:51 CST