Re: Import into a database takes a long time

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.

Jim.Pickett_at_cubic.com wrote:

> Platinum has a product that they claim will restore data from an export
> file 8+ times faster than Oracle's import function. Apparently, they read
> the export file and create SQLLDR compatible input files from that data and
> jam it in. I have not seen this product in action, but it sounds like a
> "faster" way to do importing... Anyone out there using this product ?
>
> ------------------------
> From: MTaylo1987 <mtaylo1987_at_aol.com>
> Subject: Import into a database takes a long time
> Date: 20 Nov 1998 14:51:28 GMT
> Location: news://news/comp.databases.oracle.server/19981120095128.02581.00000319@ng42.aol.com
> To: "comp.databases.oracle.server" <@news:comp.databases.oracle.server_at_news>
>
> I am trying to do an import of data into a database using the standard import
> facility but it seems to take forever. What areas should I look at for possible
> performance gains.
>
> Ta
>
> Mike
> ---------------End of Original Message-----------------
>
> ======================================
> Jim Pickett
> Manager of Database Administration
> Cubic Corporation
>
> Work: (619)505-2868
> Pager: (619)494-5539
> E-mail: jim_pickett_at_cubic.com
>
> 11/24/1998 07:01:12
> ======================================
Received on Wed Nov 25 1998 - 13:23:45 CST