Re: Large Transfer
From: Frank van Bortel <fbortel_at_home.nl>
Date: Fri, 09 Feb 2001 12:42:23 GMT
Message-ID: <3A833D29.A8DA84D8_at_home.nl>
Date: Fri, 09 Feb 2001 12:42:23 GMT
Message-ID: <3A833D29.A8DA84D8_at_home.nl>
What version 8? If 8i (aka 8.1.5 or up), consider transportable tablespaces.
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.
>
> Many Thanks
>
> ------------------------
>
> bobnewtweb
-- Gtrz, Frank van BortelReceived on Fri Feb 09 2001 - 13:42:23 CET