Re: Reg Partition Exchange

DA Morgan wrote:
> 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

Two schemas in a single database. Received on Tue Jun 27 2006 - 00:05:16 CDT