Re: Tool for getting data logically our of the database not using EXPORT

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Thu, 28 Dec 2000 13:24:52 -0800
Message-ID: <92gb1p$o04$1_at_spiney.sierra.com>


I had to move 7.2.3 data to an 8.0.6 instance.

I created database links and moved the data using INSERT. Was fast enough, but required building indexes on destination.

"Thomas Rudy" <tdrudy_at_ix.netcom.com> wrote in message news:92edgi$mp6$1_at_slb1.atl.mindspring.net...
> All,
>
> Does anyone know of a stable and fast tool that can get data logically
> out of the database without using EXPORT? We need to pull the data out of
 a
> 7.3.3.6
> Solaris database consisting of about 500G of data and put it into an
> 8.1.6/8.1.7 database.
> EXPORT is too slow (even on extremely fast systems) as this database
> supports an OLTP application and must be available to users with minimal
> downtime. We looked at one tool
> but it was not stable and could not handle the data fast enough.
>
> Appreciate any help you may be able to give on the tool.
>
> Thanks,
>
> Tom
>
>
>
>
>
Received on Thu Dec 28 2000 - 22:24:52 CET

Original text of this message