Re: Moving Large Volumes of Data between 2 Oracle Databases

From: Ranga Chakravarthi <ranga_at_cfl.rr.com>
Date: Sat, 03 Nov 2001 17:32:37 GMT
Message-ID: <VSVE7.3718$zK1.1966509@typhoon.tampabay.rr.com>

Hi Arun,

Have you tried transportable tablespaces?

-Ranga

"Arun J Muthalaly" <arunjacob_at_hotmail.com> wrote in message news:c0da5cec.0111020722.1f70bc66_at_posting.google.com...
> Hi,
>
> I have moved Gigabytes of data using the direct load method between
> Oracle databases having tables with same structure ie by using insert
> /+* APPEND */
> into target_table as select * from source_table.
>
> How does this compare in perfomance with using parallel query slaves
> as insert /* parallel(a,x) */ into target_table a as select /*
> parallel(b,y) */ from source_table b (x,y denotes degree of
> parallelism )? . Does the source database also need to have parallel
> query enabled ?
>
> Thanks and regards
>
> Arun
>
Received on Sat Nov 03 2001 - 11:32:37 CST