Re: Help with Large Transfer between DBs

From: Tom Newton <thnewton_at_NOSPAMhotmail.com>
Date: Wed, 31 Jan 2001 01:46:25 GMT
Message-ID: <R7Kd6.7325$zZ.990720@news02.optonline.net>

Thanks

"Andreas Necker" <Andreas.Necker_at_isb-ka.de> wrote in message news:3A76DEC1.3885875_at_isb-ka.de...
> hi,
>
> Tom Newton wrote:
> >
> > 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.
> >
>
> if your db is an oracle 8i you can use transportable tablespaces.
>
> --
> Andreas Necker
>
> ISB AG Tel: +49 (0)721/82800-0
> Karlstrasse 52-54 Fax: +49 (0)721/82800-82
> 76133 Karlsruhe mailto:Andreas.Necker_at_isb-ka.de
> Germany http://www.isb-ka.de
Received on Tue Jan 30 2001 - 19:46:25 CST