Re: Moving Large Volumes of Data between 2 Oracle Databases

arunjacob_at_hotmail.com (Arun J Muthalaly) 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 ?

I don't expect to see much performance improvement.When I do this, I only used parallellism on building the indexes. Building and populating a 12G database in 2 hours was good enough for me.

Ronald.