Reg Partition Exchange

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 26 Jun 2006 05:28:28 -0700
Message-ID: <1151324908.723485.86920@b68g2000cwa.googlegroups.com>

Greetings,

                We have a requirement where we want to transfer some

millions of data in 15-16 tables from one schema to same structure tables in another. Both source and destination tables are partitioned. Right now we are going for partition exchange for both schemas. But as we know partition-exchange empties the source table from where it is tranferring the data.
For that we are taking help of temporary tables in between but it is really causing major performance problems. The whole process goes beyond 3-4 hrs.
Just want to know is there any way in partition-exchange where we can directly transfer the data between two tables without loosing data Or any other way some one can suggest?

We are using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

Any help would be greatly appreciated.

TIA Received on Mon Jun 26 2006 - 07:28:28 CDT