Re: Help with Large Transfer between DBs

From: Spencer <spencerp_at_swbell.net>
Date: Sun, 28 Jan 2001 14:05:06 -0600
Message-ID: <LX_c6.52$Dk2.62239@nnrp3.sbc.net>

one mechanism to consider:

exp
gzip
ftp
gunzip
imp

"Tom Newton" <thnewton_at_NOSPAMhotmail.com> wrote in message news:M_Oc6.24188$ek.3627478_at_news02.optonline.net...
> Does anyone know the best way to efficiently transfer a large number of
rows
> (up to 1million rows) intra-day from several tables in one Oracle 8
database
> to another? Are there any special utilities or methods? This needs to
> happen without any downtime on either side. Solaris environment.
>
> Many Thanks
>
>
>
>
>
> ------------------------
>
>
>
>
>
>
>
>
> bobnewtweb
>
>
>
>
>
Received on Sun Jan 28 2001 - 14:05:06 CST