Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Moving Large Volumes of Data between 2 Oracle Databases

Moving Large Volumes of Data between 2 Oracle Databases

From: Arun J Muthalaly <arunjacob_at_hotmail.com>
Date: 2 Nov 2001 07:22:13 -0800
Message-ID: <c0da5cec.0111020722.1f70bc66@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 Fri Nov 02 2001 - 09:22:13 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US