pankaj_wolfhunter_at_yahoo.co.in wrote:
> 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
Two schemas in a single database?
Two different databases?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jun 26 2006 - 14:51:12 CDT
