Re: Help with Large Transfer between DBs

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